topic How do i write a condition in expression in pivot table in QlikView

How do i write a condition in expression in pivot table

Anonymous — Mon, 05 May 2014 19:08:36 GMT

I would like to write a condition where, I want to write if there is a value in dimension then count/include in that count expression.

Gysbert_Wassenaar — Mon, 05 May 2014 19:24:22 GMT

count({<MyDimension1={'A'}>} MyDimension1)

Note, if MyDimension1 is a key field that's linking two or more tables then use another non-key field to count:

count({<MyDimension1={'A'}>} MyDimension2_NotAKey)

javier_florian — Mon, 05 May 2014 19:25:15 GMT

Hi Surender,

Yes, you can create an expression like this:

=Count(Distinct ID)/If(Flag1='Yes',2,1)

Or something more complex like that:

=(Count({<Flag1={"Triple"}, Año={$(vMaxAño)}, Mes={"<=$(=Num(Max(Mes)))"}>} Distinct ID)/3)

+(Count({<Flag1={"Si"}, Año={$(vMaxAño)}, Mes={"<=$(=Num(Max(Mes)))"}>} Distinct ID)/2)

+(Count({<Flag1={"No"}, Año={$(vMaxAño)}, Mes={"<=$(=Num(Max(Mes)))"}>} Distinct ID))

-JFlorian

Anonymous — Mon, 05 May 2014 21:02:21 GMT

Thank you, it worked.