I am trying to create the below chart in QlikView. It is basically the no. of open claims vs the no. of days they are open for. I am stuck with the dimension for this chart, as you can see it shows the count of claims. Can someone help me with the dimension part of this chart? The expression is simple : "num(today())-num(Start_Date)"
The idea of this chart is to show users that - for eg., around 121 claims are open for 1000 to 1250 days.
no. of days open for each claim can be calculated using Claim_ID. Basically, if I provide a serial number to every Claim_ID in the chart then I should be able to get the chart I am looking for, So that would actually give me a count.