Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Master
Master

Re: How to use the "Total" better

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

View solution in original post

1 Reply
Highlighted
Master
Master

Re: How to use the "Total" better

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

View solution in original post