topic pivot table total issue in QlikView

pivot table total issue

Anonymous — Mon, 08 Dec 2014 16:04:45 GMT

Here in this pivot table i m having the issue with the Performance Total it is varying .

It should be Sum([Coperate SLP])*[Performance])

Means (103*106)+(0*111)=109.18 but its displaying as 111 that is the problem over here.

Help me guys since a week i m striving to get it done but its not getting perfect.

i have attached the expressions also .

Mon, 08 Dec 2014 23:50:13 GMT

Can't see the expressions. Can the whole qvw be attached?

Anonymous — Tue, 09 Dec 2014 03:32:33 GMT

hi alexander ,

Can u share me u r mail id please.

Tue, 09 Dec 2014 05:06:55 GMT

This post might help you.

Instead average exp you should put your exp.

Thanks

Ravi Balar.

Anonymous — Tue, 09 Dec 2014 05:20:27 GMT

hey i have posted my screen shot tough to evaluate and can u ping me by mail i can show u my dashboard

Tue, 09 Dec 2014 05:23:24 GMT

Can I have your mail id?

Tue, 09 Dec 2014 05:30:29 GMT

You can put this as expression

avg(aggr(sum(A)/sum(B),C))

its_anandrjs — Tue, 09 Dec 2014 05:44:43 GMT

Hi bunnyqlik,

Better if you share the sample dummy application with few rows that can help for better understand and for help.

Regards,

Anand