Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Sum(Value) / Sum(Total <Class> Value)
you can use the Total to calculate the value at the Class level
sum(value)
/
sum(Total <Class> value)
replace with your expression