Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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
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.
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
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.