topic Re: Filter on Calculation in QlikView

Filter on Calculation

ljames88 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Filter on Calculation

sunny_talwar — Tue, 24 May 2016 02:28:31 GMT

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%')))

Re: Filter on Calculation

ziadm — Tue, 24 May 2016 04:40:45 GMT

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)