Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rmuhammad
Creator
Creator

Set analysis and user selection using filters

Hi All

Following is the expression I have where taking only values with status A and T. But at the same time I have List box for Status and user select only A or T. In this situation selection not taking affect to the results.

Count({<STATUS={'A','T'}>}EMPLID)

how do i limit data to A and T but also at the same time give user an option to select A or T?

1 Solution

Accepted Solutions
sunny_talwar

Try this

Count({<STATUS *= {'A','T'}>} EMPLID)

Read more about Implicit Set Operators

View solution in original post

3 Replies
sunny_talwar

Try this

Count({<STATUS *= {'A','T'}>} EMPLID)

Read more about Implicit Set Operators

luismadriz
Specialist
Specialist

Thanks for sharing this Sunny, I wouldn't know how to look for those. Cheers. Luis.

rmuhammad
Creator
Creator
Author

It works and thanks for the article link.

regards

Rashid