topic Re: Condicional Expression - Last expand in QlikView

Condicional Expression - Last expand

Fri, 29 Jun 2012 14:34:25 GMT

I have a expression that is conditional and only appear when I expand the last column of dimension, how to do this? Thanks.

Jason_Michaelides — Fri, 29 Jun 2012 14:41:57 GMT

If(Dimensionality()=YourLastDimensionNumberHere,YourExpressionHere)

Hope this helps,

Jason

Fri, 29 Jun 2012 14:59:54 GMT

Thanks, but i put this expression in condicional field?

Fri, 29 Jun 2012 15:05:14 GMT

You can give me someone example (qvw file)?

Jason_Michaelides — Fri, 29 Jun 2012 15:24:10 GMT

Say you have 3 dimensions in the pivot table and your expression to only calculate if the last one is expanded is Sum(Sales)....

Instead of Sum(Sales) as the expression, use:

If(Dimensionality()=3,Sum(Sales))

The third part of the IF() statement (the ELSE bit) is absent (Null) so the expression shouldn't appear at all.

Fri, 29 Jun 2012 16:19:21 GMT

OK, but the column don't disappear, i think with this function the column with expression just appear when dimensionality() = 3...

Jason_Michaelides — Fri, 29 Jun 2012 17:17:26 GMT

You could try adding in the Null bit -

If(Dimensionality()=3,Sum(Sales),Null())