Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to filter based on expression?

I want to filter based on:

Revenue < 100

How can I do this?

4 Replies
MVP
MVP

Re: How to filter based on expression?

Filter in during the load?

May be this after your load statement

LOAD fieldNames

FROM Source

Where Revenue < 100;

alextimofeyev
Contributor II

Re: How to filter based on expression?

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

Re: How to filter based on expression?

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
Contributor II

Re: How to filter based on expression?

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