Discussion board where members can get started with QlikView.
I want to calculate the monthly loss ratios using data from the following table.
I want to create a straight table that looks like the following loss ratios:
In the Dimensions, I have selected the 'Scheme' and in the Expression tab, I tried to calculate for month 2 using the following formula:
=if(Month=2, sum(Claims)/sum(Premiums)*100, 0)
This is producing wrong results. Please help..
load the table as
MONTH(date#(Month,'MM')) as month_name
Add a pivot table
dimensions1 - Schemes
dimension2 -Month name
You may need to drag the column horizontally in Qlikview