Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Hi,
No of days open is your open day bucket??
How you are calculating No of days open???
You can use it as calculated dimension.
Regards,
Prashant
Hi Prashant,
Thank you for the reply.
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.