Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

divya_anand
Contributor II

"no. of items" as dimension?

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.

Tags (2)
2 Replies

Re: "no. of items" as dimension?

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

Regards,
Prashant Sangle
divya_anand
Contributor II

Re: "no. of items" as dimension?

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.

Community Browser