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

[Max_]

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 🙂

[Or · Accepted solution]

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;