Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
kalyandg
Partner - Creator III
Partner - Creator III

First Dimension's Partial Sum Value used for each row percentage calculation in pivot.

Hi All,

I have a requirement from one of my Customer, in Pivot table.

There are four to five dimensions, more expressions.

First dimension is Product Group, .........

First Measure is Target Value

Next Measure is Contri %

Second measure calculation should be each row Target value / each ProductGroup's partial sum (Total) target value.

Generally we calculate as Sum(Target)/Sum( Total Target), but this wont work, because Total will be taken from Grand Total, but the requirement is each ProductGroup's total value.

Is it Possible in Qlikview pivot table?

i have attached the Sample application with this discussion.

Please help.

Thanks and Regards,

Kalyan

1 Solution

Accepted Solutions
tresesco
MVP
MVP

May be like:

sum([Month Target])/sum(TOTAL <PRODGRP> [Month Target])

View solution in original post

3 Replies
tresesco
MVP
MVP

May be like:

sum([Month Target])/sum(TOTAL <PRODGRP> [Month Target])

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

My solution would be the same as tresesco:

Screenshot_1.jpg

Works as you wish.

kalyandg
Partner - Creator III
Partner - Creator III
Author

Hi Mindaugas Bacius,

Thanks for your reply.