***************Need help with finding Initial Amount

Thu, 17 Sep 2015 20:17:15 GMT

Hello,

Just trying to get this chart to work.

Basically I have 2 list boxes:

YearMonth

AccidentYear

For YearMonth I have 3 possibilities: (We'll select only one of these at a time, the idea being to have a yearmonth selected with all AY's)

201505

201506

201507

And 2 possibilities for AccidentYear: (these two will always be selected to display AY across both years)

2009

2010

The idea is to represent the inline table(visible in script) data in a bar chart. The Dimension being a combination of Year(DateOfInjury), and ClaimNumber (i.e. 2010-1)

I want to have this chart set up so that it has for each value of the Year-ClaimNumber dimension, two bars, one for TotalIncurred which just grabs the max YearMonth Dimension selected, and one for InitialIncurred for the same YearClaimNumber value. I have the the logic for TotalIncurred in the chart, but the InitialIncurred Amount is alluding me. Any help would be greatly appreciated as I've spent hours on this. Thanks in advance

The idea here is to see the Max amount against what it was initially. Chart is attached

topic ***************Need help with finding Initial Amount in QlikView

***************Need help with finding Initial Amount