Percentage calculation in Qlikview?. Please help

[Anonymous]

I have attached Dashboard developed by me. I have a query to calculate percentage in this dashboard. Percentage should be calculated for Underwriting Result/Gross Premium * 100. But the problem is, all the data shown gets stored in same table and same column with different Type. How to calculate Percentage.

Attached is the image of my dashboard for your quick reference and help

[Digvijay_Singh]

What if you use your Underwriting result expression divide by Gross Premium Expression multiplied by 100?

Or if your data model doesn't permit then something like this, not sure which one could be applicable -

(Sum({<[Type Detail Desc]={'Underwriting Result'}>}Budgeted)/

Sum({<[Type Detail Desc]={'Gross Premium'}>}Budgeted))*100

[sunny_talwar]

Where exactly are you looking to calculate this? In a text box object or a chart?