How to Use and Condition in Different Filters in Qlik Sense
So I have been working with qlik sense for a while now, and I know that the default behavior of qlik is an OR operator when it comes to selections, right? Can anyone tell me how to use "AND" operator when it comes to filter panes.
Re: How to Use and Condition in Different Filters in Qlik Sense
Assume we have a list of companies, each company can have activities from the list A, B ,C.
Company1 has activities A and B
Company2 has activities A
Company3 has activities B and C
Company4 has activities A, B and C
now if I have a filter pane and I select A and B, Qlik will count all of the above companies right? since the default behavior of Qlik is OR. Now I'd like to teach the user who to make an "AND" operator selection, so if he/ she selected A and B only Company1 and Company4 should be counted.