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: 
Not applicable

How to filter based on expression?

I want to filter based on:

Revenue < 100

How can I do this?

4 Replies
sunny_talwar
MVP
MVP

Filter in during the load?

May be this after your load statement

LOAD fieldNames

FROM Source

Where Revenue < 100;

alextimofeyev
Partner - Creator II
Partner - Creator II

If Revenue is a dimension, you can do numeric search. If it's a measure, you can do expression search.

https://help.qlik.com/en-US/sense/2.2/Subsystems/Hub/Content/Search/data-search.htm

Not applicable
Author

Hi Alex,

Would I have to select each value 1 by 1? When I click "Select Possible," all values are are selected. Even the values greater than 100.

alextimofeyev
Partner - Creator II
Partner - Creator II

After you've typed your condition, just hit enter - it should select relevant values.