topic Set analysis and user selection using filters in QlikView

Set analysis and user selection using filters

rmuhammad — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Set analysis and user selection using filters

sunny_talwar — Mon, 13 Nov 2017 23:08:27 GMT

Try this

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

Re: Set analysis and user selection using filters

luismadriz — Mon, 13 Nov 2017 23:17:02 GMT

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

Re: Set analysis and user selection using filters

rmuhammad — Tue, 14 Nov 2017 14:24:09 GMT

It works and thanks for the article link.

regards

Rashid