topic Re: Calculated dimension in an expression in QlikView

Calculated dimension in an expression

tinkerz1 — Mon, 06 Jul 2015 07:51:55 GMT

I am trying to understand how a calculated dimension fits into an expression.

If I label the calculated dimension, why cant I use this in the set analysis part of the expression?

And what is the work around?

My calculated dimension

Label 'ABC Status'

=IF(len([Action])=1,IF(([Created Date]+[Days])>[Load Date],'On Track','Overdue'),'Placed')

My Set expression

=count(DISTINCT {$<[ABC Status]={'Overdue'}> + <[ABC]={'On Track'}>} [Action])

Re: Calculated dimension in an expression

Gysbert_Wassenaar — Mon, 06 Jul 2015 08:02:26 GMT

Only fields can be used in set modifiers on the left side of the =. Expressions, expression labels and labels of calculated dimensions cannot be used.

Re: Calculated dimension in an expression

MarcoWedel — Mon, 06 Jul 2015 22:26:09 GMT

As [ABC Status] = 'On Track' or [ABC Status] = 'Overdue' should define the same set as Len(Action)=1 one solution might be:

=Count(DISTINCT {$<Action={"=Len(Action)=1"}>} Action)

hope this helps

regards

Marco