topic Pivot table Expresion group by on only first dimension in QlikView

Pivot table Expresion group by on only first dimension

suresh_qv50 — Tue, 10 May 2016 15:41:23 GMT

Hello,

I have attached my Qvw,

Please find the attachment and help me that, Pivot table there will be 3 dimension and 2 expression

The 2nd Calculated dimension and the 2nd Expression needs to give same result but here getting mismatches

We need Same due value which is in dimension in Expression(Due) too.

2. Is it possible to make 2nd Expresion is only group by on first dimension ?

Please Reply back ASAP

sunny_talwar — Tue, 10 May 2016 18:00:40 GMT

Please reduce the size of the application and then reattach

suresh_qv50 — Tue, 10 May 2016 18:38:04 GMT

Sunny The data reduced please find the attachment .

Thanks&Regards

suresh

sunny_talwar — Tue, 10 May 2016 19:03:04 GMT

Use this as your calculated dimension:

=Num(Aggr(Sum({<paidindays = {'*'}>}DueAmt),Quarter),'$#,##0')

suresh_qv50 — Wed, 11 May 2016 04:28:11 GMT

Sunny,

Your Expression working fine. I need same Equivalent result Expression in Expressions not in dimensions.

If i use the same expression in expression it displays null ('-')

If possible please help us with Expression

sunny_talwar — Wed, 11 May 2016 13:48:05 GMT

May be this in the expression:

Sum(TOTAL <Quarter> DueAmt)