topic Re: Pivot table cannot display total value in QlikView

Pivot table cannot display total value

Wed, 09 Sep 2015 09:05:42 GMT

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.

sunny_talwar — Wed, 09 Sep 2015 09:12:18 GMT

Try this expression:

=Sum(Aggr(Max(Value1),Type1, Type2))

Wed, 09 Sep 2015 09:21:18 GMT

Hi Sunny

If I use Sum(Aggr(Max(Value1),Type1, Type2)), the total value of Y is 10 instead of 5.

sunny_talwar — Wed, 09 Sep 2015 09:29:16 GMT

Try this:

=Sum(Aggr(Only(Aggr(Max(Value1), Type1, Type2)), Type2))

Thu, 10 Sep 2015 15:58:53 GMT

Sunny, Thank you very much for your help.

sunny_talwar — Thu, 10 Sep 2015 17:35:38 GMT

Not a problem

I am glad I was able to help.

Best,

Sunny