Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
AshwiniMadhusudhan
Contributor II
Contributor II

Percentage of total calculation

Hi,

 

I am new to Qlik Sense. I have my data in this format:

 Region ARegion B
 Met TATExceeded TATMet TATExceeded TAT
Company A00345
Company B70535
Company C181151
Company D1010
Company E108466984
Total134577295

 

I want to show this data so that against company B in Region A, I have a % such as: 7/(134+5 - which is Region A total)

I do not know if I am clear in explaining my requirement, so I am attaching an excel with the calculation. 

Please help me achieve this in Qlik sense

Regards,

Ashwini

2 Replies
slsaagar
Contributor II
Contributor II

Hi,

you need to use total qualifier in your expression attached the Qvf file for your ref.

 

AshwiniMadhusudhan
Contributor II
Contributor II
Author

Thanks Saagar!