Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

compare values with Partial Sum

Hi People,

I have an pivot table like below. And I need to compare each and every value in the value column for the specific class and calculate percentage.

qv1.png

I need the output like below.  The Percentage column is calculated by comparing the values in the value column with corresponding partial sums. I am pretty new to Qlikview. Kindly help me.

Class Div are Dimensions and value is Expression

qv2.png

1 Solution

Accepted Solutions
neelamsaroha157
Specialist II
Specialist II

Try this

Sum(Value) / Sum(Total <Class> Value)

View solution in original post

2 Replies
neelamsaroha157
Specialist II
Specialist II

Try this

Sum(Value) / Sum(Total <Class> Value)

maxgro
MVP
MVP

you can use the Total to calculate the value at the Class level

sum(value)

/

sum(Total <Class> value)

replace with your expression