Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 .

Labels (1)
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
Champion III
Champion III

Hi bunnyqlik,

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

Regards,

Anand