Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
My pivot table cannot display total value in Qlik Sense.
The data structure is shown below.
Type1 | Type2 | Value1 | Value2 |
---|---|---|---|
A | X | 1 | 8 |
B | Y | 5 | 6 |
C | Y | 5 | 6 |
D | Z | 7 | 9 |
From below pivot table, the total of aggr(max(Value1),Type1, Type2) should be 13. However, it cannot display value.
Does anyone help me on this? Thanks.
Try this expression:
=Sum(Aggr(Max(Value1),Type1, Type2))
Hi Sunny
If I use Sum(Aggr(Max(Value1),Type1, Type2)), the total value of Y is 10 instead of 5.
Try this:
=Sum(Aggr(Only(Aggr(Max(Value1), Type1, Type2)), Type2))
Sunny, Thank you very much for your help.
Not a problem
I am glad I was able to help.
Best,
Sunny