Help on working out the percentage

[Anonymous]

Hello....

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

Risk Profile	No. of Policies	%
Total	100
Clean Risk	50
Conviction Free	30
Claims	20

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

[sunny_talwar · Accepted solution]

May be like this:

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

[Anonymous]

Thanks Sunny T, simple but effective!