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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Trying to use the WHERE clause to filter on a variable

Hello,

I am asking for help loading REPORTING_PRINTER counts into my table.  I only want to display the cases where the count is greater than 25.

Here is the expression I am using, but it is not working:

=Count({<Count[REPORTING_PRINTERS]={">=25"}>}(REPORTING_PRINTERS))

Thank you.

11 Replies
Not applicable
Author

Thanks Sunny.  My rows still existed because I had another column with data.. all must be zero for them to not appear it seems.. thanks for the help..

sunny_talwar

Oh okay... please close the thread by marking correct and helpful responses...

Best,

Sunny