topic Re: Pivot Table Total Is Wrong in QlikView

Pivot Table Total Is Wrong

dineshm030 — Wed, 13 Sep 2017 15:10:31 GMT

Hi Friends,

I have created the pivot table but the highlighted total is wrong. Could please tell me the reason?

Below the image is for your reference.

Thanks in advance.

Anil_Babu_Samineni — Wed, 13 Sep 2017 15:13:06 GMT

May be share sample application

sunny_talwar — Wed, 13 Sep 2017 15:21:09 GMT

What is your dimension and what is your expression here?

krishnacbe — Wed, 13 Sep 2017 15:23:56 GMT

What is your expected Total?

If it is just sum of the rows select the option Expression Tab -> Total Mode -> Sum of Rows

If you want the Expression total just provide Expression Tab -> Total Mode -> Expression Total

kaushiknsolanki — Wed, 13 Sep 2017 15:28:46 GMT

Try this,

Sum(Aggr(Your Expression,Your dimensions))

For example.

Sum(Aggr(Sum(Sales),Region,State))

Regards,

Kaushik Solanki

dineshm030 — Wed, 13 Sep 2017 15:53:31 GMT

Yeah It is working fine bro. Thank you so much.