Need % calculation in pivot table for a pivoted column

[kkkumar82]

Hi Qlikers,

In the attached qvw I have two dimensions ProductID and Quarter, the Expression is Sum(Sales), I just want to find out the %of Total

by Quarter, I have pivoted the column Quarter and probably missing the expression to get the Sales% for each Product on the total sales

happened for all products in that Quarters.

Any ideas, would be great.

[Anil_Babu_Samineni · Accepted solution]

Use this?

Sum(Sales)/Sum(Total <Quarter> Sales)

[kkkumar82]

thanks anil for your reply but that isn't work, showing all zeroes%

[Anil_Babu_Samineni]

Strange, Look here

[kkkumar82]

I achieved this using the below expression, I got the expected

RangeSum(Above(Sum(Sales),1,NoOfRows(TOTAL))) + RangeSum(Below(Sum(Sales),0,NoOfRows(TOTAL)))

Any other ways apart from this

stalwar1‌

[kkkumar82]

Which version are you using ?

[kkkumar82]

You were correct, I made a typo.

Any idea that this works the same in Qliksense. Mean While I will give a try