Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
schumi1980
Contributor III
Contributor III

How to use the "Total" better

Hi All

I have insurance claims. I Put this claims into several categories according to size (A till I).

For this category I would like to calculated the loss ratio as sum(Claims)/sum(Total Premium).

Is it possible to make the Total only react to certain dimensions (such as the claims size), but not others? For example:

It should calculate sum(claims)/sum(total premium) only for the gross claims banding dimension, but it should regconize that the "total" is for the producing region (e.g. Russia and Hungary) but not the sample total (the numbers below take the sample total, not the individual country as the total).

   

ProducingRegionsGross Claims BandingGross ClaimsGross Loss Ratio
RussiaB: 0-100k2'819'6870%
RussiaC: 100-250k1'536'0331%
Russia😧 250-500k849'0421%
RussiaF: 1-2.5M10'280'69810%
HungaryA: 0k-52'7180%
HungaryB: 0-100k5'377'4015%
HungaryC: 100-250k1'991'2842%
Hungary😧 250-500k1'896'1172%
HungaryE: 500-1M3'987'3524%
HungaryF: 1-2.5M1'788'3402%
HungaryG: 2.5-5M9'443'08610%
HungaryH: 5-10M14'440'14914%
HungaryI: 10-25M31'652'69331%
Total 86'009'16482%

Many thanks for your help.

Best regards,

Jan

1 Solution

Accepted Solutions
stabben23
Master
Master

Hi, use this formula in Expression sum(Claims)/sum(Total <ProducingRegions>Premium)

View solution in original post

1 Reply
stabben23
Master
Master

Hi, use this formula in Expression sum(Claims)/sum(Total <ProducingRegions>Premium)

View solution in original post