topic Re: Filtering off an Expression in QlikView

Filtering off an Expression

ysiroong — Wed, 03 Jan 2018 15:58:50 GMT

Hi.

I'm trying to build a filter based off an expression field. The field shows the net amount between two other values and I want to create a filter to exclude any records that return a zero amount.

The filter needs to be dynamic as I will be using other filters to limit the data set. The full table contains other data points so I can't use the suppress zero values option.

For example, I have the chart below

If I select a filter to reduce data in A Net, the table changes to

I want the filter to now see the 0 variance in A to B Variance and drop the record from the chart.

Does anyone know of a way to do that?

Re: Filtering off an Expression

sunny_talwar — Wed, 03 Jan 2018 16:02:52 GMT

May be something like this

If(A to B Variance Expression <> 0, A Net Expression)

If(A to B Variance Expression <> 0, B Net Expression)

A to B Variance Expression

Or you can use a calculated dimension like this

Aggr(If(A to B Variance Expression <> 0, [GL Code]), [GL Code])

Re: Filtering off an Expression

jhoef-pv — Wed, 03 Jan 2018 16:31:11 GMT

Hi,

Dimensión:

If(VarA_B <> 0, [GL Code], null())

VarA_B is A to B Variance expression.