Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this:
Sum([No. of Policies])/Sum(TOTAL [No. of Policies])
Thanks Sunny T, simple but effective!