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

how to calcuate percentage value

Hi,

I am facing problem in calculating percentage value. Please see attachment. I have 2 pivot table; Tertial and Tertial-1. I have to calculate ratio in Tertial-1 table based on Tertial total(for each HI, MI and Others value).

For e.g. if i take Q4 2014:

HI% = 110/413*100

MI%= 192/413*100(which i am getting correct in Tertial-1 table as 46.49%)

Others= 111/413*100

But I'm getting % value only for MI and not for HI & Others. Can anyone help me how to get those values ?

FYI: In Tertial-1 I'm using below expression for Ratio

sum({$<Month_Key = {"<=$(=min(Month_Key) - 100)>=$(=max(Month_Key) - 100)"}>}[Invcd. qty])/aggr(sum({$<Month_Key = {"<=$(=min(Month_Key) - 100)>=$(=max(Month_Key) - 100)"}>}[Invcd. qty]),Quarter)

Note: I have used month_key & month_key-100 to display last 12 months data only(that's how my application is).

Any help is much appreciated !

Thanks,

Roushan

0 Replies