Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
schumi1980
Contributor III
Contributor III

Pivottables, dimensions, formulae, graphs

Hi All,

I have data which I calculated in the following table, each row is a formula sum(Claims)/sum(GEP).

   

PeriodLoss Ratio
Month 154.5
Month 255.7
Month 357.8
Month 457.9
Month 559.8
Month 658.7
Month 760.7

I would like to have calculated using the dimension Underwriting Year:

   

PeriodLoss Ratio UWY 2014Loss Ratio UWY 2015
Month 155.522.8
Month 256.723.7
Month 355.826.7
Month 458.930.5
Month 560.829.6
Month 659.755.5
Month 766.7

56.7

However, when I add the dimension, I calculates not the individual loss ratios per UWY. If I created a table for each UWY, I would use the formula sum({<UWY='2014'>}Claims)/sum({<UWY='2014'>}GEP).

But I would like to be able to creat a graph like this:

How would I do that? As I am not an English speaker, I am unsure what to look for in the forum.

Many thanks for your help and sorry, if this question has already been asked.

Best regards,

Jan

2 Replies
Anil_Babu_Samineni

May be create like below

Dimension - Period

Label - ='Loss Ratio UWY' & Max(Year)-1

Expression 1 - sum({<UWY={'2014'}>}Claims)/sum({<UWY={'2014'}>}GEP)

Or This is for Dynamic

sum({<UWY={'$(=Max(Year)-1)'}>}Claims)/sum({<UWY={'$(=Max(Year)-1)'}>}GEP)


Label - ='Loss Ratio UWY' & Max(Year)

Expression 2 - sum({<UWY={'2014'}>}Claims)/sum({<UWY={'2014'}>}GEP)

Or This is for Dynamic

sum({<UWY={'$(=Max(Year))'}>}Claims)/sum({<UWY={'$(=Max(Year))'}>}GEP)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sergio0592
Specialist III
Specialist III

If Year is a dimension, you can simply create a pivot chart with Year as column. And after trasform your pivot in graph.