topic Re: dimension expression using variable in QlikView

dimension expression using variable

Anonymous — Wed, 04 Oct 2017 15:11:26 GMT

Hi!

I have a variable called vSurplus with this definition

if(ProductSpec = 'DN' or ProductSpec = 'MP' or ProductSpec = 'X' or ProductSpec = 'CL', ProductLevel-max(ProductDemand*3,ProductMinLevel) ,ProductLevel-max(ProductDemand*3,ProductOrderPt) )

So I have a column expression Surplus with this (ProductAvgCost/ProductPerUnit)* $(vSurplus) (works fine)

I am trying to set the first dimension product acording to this : if ( (ProductAvgCost/ProductPerUnit)* $(vSurplus) >0 and ProductSpec<>'O', Product )

So this way I can supress null value ...

But that does not work ... I always have nothing selected ... Maybe I am not using my variable the good way?

Re: dimension expression using variable

sunny_talwar — Wed, 04 Oct 2017 15:41:17 GMT

Is this the name of the field?

ProductLevel-max(ProductDemand*3,ProductMinLevel)

ProductLevel-max(ProductDemand*3,ProductOrderPt)

Or is this some kind of calculation?

Re: dimension expression using variable

Anonymous — Wed, 04 Oct 2017 16:19:48 GMT

A calculation ...

ProductLevel, ProductDemand , ProductMinLevel , ProductOrderPt are fields

max is a function

Re: dimension expression using variable

sunny_talwar — Wed, 04 Oct 2017 16:23:53 GMT

In that case you will need a Aggr() function as calculated dimensions with aggregation functions require you to use Aggr()

Calculated Dimensions

Re: dimension expression using variable

Anonymous — Wed, 04 Oct 2017 17:20:48 GMT

Thanks ... Reading and experimenting with aggr... will come back if I can't figure it out ...