If statement in filter pane formula when having groups with an intersection

Max_ — Mon, 27 Jun 2022 13:04:10 GMT

Hi guys,

i have my issues with the filter panes in Qlik. Here is a short description what i want to achieve:

I need a filter, where i can select "Persons with dogs" and "Persons with cats".

If i write the formula "if(dog=1,'Persons with dogs', if(cat=1,'Persons with cats')) the problem ist, that Person 3 is not in the group of 'Persons with cats', it is just in the group of 'Persons with dogs'). With which formula can i achieve that person 3 is in both groups ?

Thank you very much in advance for your answers 🙂

Re: If statement in filter pane formula when having groups with an intersection

Or — Mon, 27 Jun 2022 13:07:09 GMT

Load Person, 'Person with dog' as Filter

From YourTable

Where dog = 1;

concatenate

Load Person, 'Person with cat' as Filter

From YourTable

Where cat = 1;

topic If statement in filter pane formula when having groups with an intersection in App Development

If statement in filter pane formula when having groups with an intersection

Re: If statement in filter pane formula when having groups with an intersection