Forum Discussion
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 f...
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