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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ljames88
Contributor
Contributor

Filter on Calculation

I want to be able to filter on a calc in a table.

For example, I have a project list that shows a gross margins, and I want to setup a filter that will show Gross Margins Greater than 50, between .30 and .49 and less than .30.

How can I do that?

Thanks

2 Replies
sunny_talwar

May be create a list box like this:

If(GrossMargin >= 0.50, '>=50%',

If(GrossMargin > 0.50 and GrossMargin < 0.30, '30% - 49%',

If(GrossMargin <= 0.30, '30%')))

ziadm
Specialist
Specialist

if you have a specific range of GrossMargin use Class function

Load

Class(GrossMargin,10)  as MargingGroup

if you have a variable range of GrossMargin

Then refer to this community blog

Custom Filter(unusual range)