Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
bunnyv123
Contributor II

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 .

Tags (1)
7 Replies
Not applicable

Re: pivot table total issue

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

bunnyv123
Contributor II

Re: pivot table total issue

hi alexander ,

Can u share me u r mail id please.

Not applicable

Re: pivot table total issue

This post might help you.

Instead average exp you should put your exp.

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

Thanks

Ravi Balar.

bunnyv123
Contributor II

Re: pivot table total issue

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

Re: pivot table total issue

Can I have your mail id?

Or can you ping to balar_hasmukhbhai@infosys.com

Not applicable

Re: pivot table total issue

You can put this as expression

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

Re: pivot table total issue

Hi bunnyqlik,

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

Regards,

Anand