Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

pivot table total issue

pivot performance total.PNG.png

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 .

7 Replies
Not applicable
Author

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

Anonymous
Not applicable
Author

hi alexander ,

Can u share me u r mail id please.

Not applicable
Author

This post might help you.

Instead average exp you should put your exp.

http://community.qlik.com/thread/63590

Thanks

Ravi Balar.

Anonymous
Not applicable
Author

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

Not applicable
Author

Can I have your mail id?

Or can you ping to balar_hasmukhbhai@infosys.com

Not applicable
Author

You can put this as expression

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

its_anandrjs

Hi bunnyqlik,

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

Regards,

Anand