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: 
Anonymous
Not applicable

Help on working out the percentage

Hello....

I'm new to Qlik and looking to see how you work out the percentage of a total, example below:

Risk ProfileNo. of Policies%
Total100
Clean Risk50
Conviction Free30
Claims20

I have a table like this but want to do the percentage of the risk profile against the total i.e. Clean Risk percentage would be 50 / 100 = 50%.

Could you help please, I am sure this is easy when you know how

Thanks Tom

1 Solution

Accepted Solutions
sunny_talwar

May be like this:

Sum([No. of Policies])/Sum(TOTAL [No. of Policies])

View solution in original post

2 Replies
sunny_talwar

May be like this:

Sum([No. of Policies])/Sum(TOTAL [No. of Policies])

Anonymous
Not applicable
Author

Thanks Sunny T, simple but effective!