topic Re: Net Change in QlikView

Net Change

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have an Excel sheet that shows a ticket's Created Date and a Status Date. I'd like to know the total count of tickets on a given day MINUS the count of tickets Closed that day to get a net change in ticket count.

Example:

January 1st 2017 : 500 tickets with created date equal to 1/1/2017

200 tickets with status=Closed AND Status Date = 1/1/2017

= 300 Net tickets for 1/1/2017

How do I graph this with the proper expressions?

Re: Net Change

albertovarela — Thu, 09 Feb 2017 16:36:48 GMT

Can you post some sample data?

Re: Net Change

Anonymous — Thu, 09 Feb 2017 18:20:37 GMT

Re: Net Change

Thu, 09 Feb 2017 19:59:45 GMT

A Combo Chart cannot have more than 1 measure (Case count) when 2 dimensions (Date and Status) are included. In such cases a second measure (Net Change) for line chart cannot be added. But if you treat all the 3 as measures (Cases Created, Cases Closed and Net Change) then 2 measures can be stacked and the other one can be displayed as Line in the Combo Chart. Attached is the solution for your reference.

Have a nice day!

Re: Net Change

Digvijay_Singh — Thu, 09 Feb 2017 20:33:15 GMT

May be something like this, not sure though

Re: Net Change

albertovarela — Thu, 09 Feb 2017 20:59:41 GMT

I'd like to suggest a different approach where New tickets add up and Close subtract. I hope this helps...

Re: Net Change

MarcoWedel — Thu, 09 Feb 2017 22:13:58 GMT

Hi,

maybe helpful:

Canonical Date

regards

Marco