topic Re: Expression as a dimension in QlikView

Expression as a dimension

bobbydave — Tue, 02 Jun 2015 14:40:43 GMT

=if([Data Category]<>'Adjusted', null(), avg(ACT_GBP.Materiality))

Any ideas how I would write the above as a dimension?

sunny_talwar — Tue, 02 Jun 2015 14:46:19 GMT

You will need some kind of Aggr function here. What exactly are your Averaging ACT_GBP.Materiality over (which dimension)?

=If([Data Category]<>'Adjusted', null(), Aggr(avg(ACT_GBP.Materiality), DimensionName))

or may be this

=If([Data Category] = 'Adjusted', Aggr(avg(ACT_GBP.Materiality), DimensionName))

rubenmarin — Tue, 02 Jun 2015 14:47:09 GMT

So, you want the average of ACT_GBP.Materialty where [Data Category]='Adjusted'?

It can be: Avg({<[Data Category]={'Adjusted'}>} ACT_GBP.Materiality)

Just to advise, you can create expressions without dimension if you only want a bung of predefined calculations.

marcus_sommer — Tue, 02 Jun 2015 14:48:07 GMT

Have a look here:

- Marcus