Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator 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 .

7 Replies
Highlighted
Not applicable

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

Highlighted
Creator II
Creator II

hi alexander ,

Can u share me u r mail id please.

Highlighted
Not applicable

This post might help you.

Instead average exp you should put your exp.

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

Thanks

Ravi Balar.

Highlighted
Creator II
Creator II

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

Highlighted
Not applicable

Can I have your mail id?

Or can you ping to balar_hasmukhbhai@infosys.com

Highlighted
Not applicable

You can put this as expression

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

Highlighted

Hi bunnyqlik,

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

Regards,

Anand