Skip to main content
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

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.