When filtering a Table(view), is there a way of rearranging the order of the filters I have added? Since I am working with “and” and “or” I need a way of adding a filter to a previously defined group of “or” filters.
Also another question regarding the handling of the “or” operator in this case. Lets imagine I have filters set up like this:
will it be interpreted as A and (B or C) and D or as (A and B) or (C and D)?
If the former is the case, is there a way of creating the latter? (workaround would be with formulas I imagine)
How it is executed depends on how you present it.
I have created a demo doc here.
The filter I have used is that the Name number must be greater than 1 and less than 3, or greater than 4 and less than 5. This should limit the result to rows of 2 or 5 only.
The filter can be written as:
OR(thisRow.Name>1 AND thisRow.Name<3 , thisRow.Name>4 AND thisRow.Name<6)
Simplified this will be: OR( A AND B, C AND D)
(thisRow.Name>1 AND thisRow.Name<3) OR (thisRow.Name>4 AND thisRow.Name<6)
Simplified this will be: (A AND B) OR (C AND D)
The bracket locations are important as they dictate where the arguments start and end.
Argument 1 is (thisRow.Name>1 AND thisRow.Name<3)
Argument 2 is (thisRow.Name>4 AND thisRow.Name<6)
In the middle is the OR. So if a row meets all the conditions of Argument 1 OR the conditions of Argument 2 then display it.
I have thrown in some additional more complex examples.
I hope that this makes sense and helps.
Thank you very much for your reply. Could you please grant me editing rights to the doc so I can view the filters you have created?
Thank you very much. I also just discovered the function to transform all the filters into one function.
Thank you for your help.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.