Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Try this

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

View solution in original post

2 Replies
Highlighted
Specialist II
Specialist II

Try this

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

View solution in original post

Highlighted
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