Forum Discussion

ortiz99's avatar
ortiz99
Regular Visitor
3 years ago

AND Logic Slicer

Hello!

 

I have a table with 3 columns like the one below:

 

 

Then, I have a smart silcer by okviz with an OR logic, like the one below:

 

I want that, when I search for example for "Tool1" and "Tool 3", then, in another table like the next one, appear the codes that contain any type of experience (1, 2 or 3) in the tools searched (in this case, 123 and 543)

 

The slicer has to have AND logic.

 

Thank you very much!

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi ortiz99 ,

    I'm a little confused about your needs, Could you please explain them further? 

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_Binbin Yu

  • ortiz99's avatar
    ortiz99
    Regular Visitor
    3 years ago

    I mean,

     

    Imagine you search in the slicer for Tool 1 and Tool 3. If you look in the table, for code 123, Tool 1 has 1 of exp, and Tool 3, has 1 of exp. Also, for 543, Tool 1 has exp 3 and Tool 3 has exp 3. But for code 894, Tool 1 has exp 2 and tool 3 has exp None.

     

    So, I want that, when I search for Tool 1 and Tool 3, in the last table whose header is "Code", appear codes 123 and 543, because they are the ones that, for the tools searched, have almost a number of experience (exp). And 894 shouldn't appear because in Tool 3, it has experience "None"

     

    Ask me if necessary for any doubt.

     

    Thank you very much