Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
IIIIIAIIIII
Contributor II
Contributor II

How do I get the qlik sense filter to do or operate on a condition of filter 1 or a condition of filter 2 to filter data?

We now have 3 bars of data: the first is ID 1,name aaa,gender:boy, the second is ID 2,name bbb,gender:boy, and the third is Id 3,name ccc,gender: gril, now I want to use the filter provided by qlik sense to filter all the data whose name is aaa or gender is girl. How can I achieve this? Normally you should get data with ID 1 and ID 3

Qlik Cloud

Labels (1)
4 Replies
MatheusC
Specialist II
Specialist II

@IIIIIAIIIII 
Can you provide an example of the data, and what output you are looking for. It is still not clear what information is contained in your table, and what the desired result is.

Tip: Always try to insert your publications in the forums/tags that are most related to your issue. It will always be more practical and faster when you pay attention to these details 🙂

- Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
IIIIIAIIIII
Contributor II
Contributor II
Author

For example, there are three pieces of data:
Name,gender
[aaa,boy]
[bbb,boy]
[ccc,gril]
Normally, I only use the gender filter and selecting 'boy' will show up in the table:
[aaa,boy]
[bbb,boy]
If 'girl' is checked in the gender filter, it appears in the table:
[ccc,gril]
If I checked 'boy' in the gender filter, then I checked 'aaa' in the Name filter
[aaa,boy]
This is not what I expected, however, and qlik sense intersects multiple filters.
The result I expect is that if 'boy' is selected in the gender filter, then 'aaa' is selected in the Name filter
[aaa,boy]
[bbb,boy]
It represents data with a gender of boy or a Name of aaa.

MatheusC
Specialist II
Specialist II

I'm going to take a guess because I'm not really sure what you're looking for yet.

Let's say the scenario is that you want a count where the Gender is Male and the Name is John, then you can define this in your analysis set:

count({<Name={'aaa'},gender={'boy'}>}distinct ID)

Then the filters are applied respecting these two criteria.

- Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
IIIIIAIIIII
Contributor II
Contributor II
Author

The main thing is to use this method to write how many types in advance to judge the conditions. And I want to display the selected data in a table, not count it.