"no. of items" as dimension? - Qlik Community

divya_anand · ‎2017-07-26

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.

PrashantSangle · ‎2017-07-26

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

divya_anand · ‎2017-07-26

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.