Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
navaskhan
Contributor III
Contributor III

Pivot and Percentage

    Ho to achieve this in Pivot Table with Aggr Function ?

CustomerJanJan %
A

50

50%
B1010%
C2020 %
D2020 %
100100 %
1 Solution

Accepted Solutions
sunny_talwar

Try this:

Sum(Measure)/Sum(TOTAL <Customer> Measure)

or

Sum(Measure)/Sum(TOTAL <Month> Measure)

View solution in original post

4 Replies
vikasmahajan

=column(2)/100   and  tick on Show in %

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
sunny_talwar

May be this:

Sum(Measure)/Sum(TOTAL Measure)

navaskhan
Contributor III
Contributor III
Author

This is not working in case of Multiple Months. Because Total will take the Jan & Feb Total.

sunny_talwar

Try this:

Sum(Measure)/Sum(TOTAL <Customer> Measure)

or

Sum(Measure)/Sum(TOTAL <Month> Measure)