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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
maasool
Contributor III
Contributor III

Measure as a filter

Hello Dear Qlik Community,

I have a table, with 10 dimensions and 2 measures. I would like to:

1) Create a Filter pane, where user could filter one of the measures:
a) values higher than 100; b) values higher than 1 000.

2) Show in table only these rows, where value of  one measure is higher than 1.

How to achieve these goals?

Best regards
maasool

2 Replies
Uday_Pasupuleti
Partner - Creator III
Partner - Creator III

Create a flag in script and use that as a filter.
maasool
Contributor III
Contributor III
Author

For problem 1) it does the work. It is suitable for 2) as well, but what if I want to keep this selected all the time (no matter what values are in initial table, my app is showing only values higher than 1)?