Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
tomhassall
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
Not applicable

Re: Help on working out the percentage

May be like this:

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

2 Replies
sunny_talwar
Not applicable

Re: Help on working out the percentage

May be like this:

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

tomhassall
Not applicable

Re: Help on working out the percentage

Thanks Sunny T, simple but effective!