Discussion board where members can get started with Qlik Sense.
I'm new to Qlik and looking to see how you work out the percentage of a total, example below:
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
Go to Solution.
May be like this:
Sum([No. of Policies])/Sum(TOTAL [No. of Policies])
Thanks Sunny T, simple but effective!