# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for
Did you mean:  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).

 Period Loss Ratio Month 1 54.5 Month 2 55.7 Month 3 57.8 Month 4 57.9 Month 5 59.8 Month 6 58.7 Month 7 60.7

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

 Period Loss Ratio UWY 2014 Loss Ratio UWY 2015 Month 1 55.5 22.8 Month 2 56.7 23.7 Month 3 55.8 26.7 Month 4 58.9 30.5 Month 5 60.8 29.6 Month 6 59.7 55.5 Month 7 66.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.

Best regards,

Jan

2 Replies  MVP

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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)  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. Community Browser