Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to filter based on:
Revenue < 100
How can I do this?
Filter in during the load?
May be this after your load statement
LOAD fieldNames
FROM Source
Where Revenue < 100;
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
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.
After you've typed your condition, just hit enter - it should select relevant values.