topic compare values with Partial Sum in QlikView

compare values with Partial Sum

Wed, 25 Nov 2020 16:16:04 GMT

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.

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

Re: compare values with Partial Sum

neelamsaroha157 — Wed, 21 Sep 2016 16:16:05 GMT

Try this

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

Re: compare values with Partial Sum

maxgro — Wed, 21 Sep 2016 16:20:01 GMT

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

sum(value)

sum(Total <Class> value)

replace with your expression