topic Backlog Calculation for Bar Chart in QlikView

Backlog Calculation for Bar Chart

Fri, 20 Nov 2020 18:02:30 GMT

Hi All,

I need your help, I have attached an excel file where I am having data as below,

Month	# Opened Request	# Closed Request	Backlog	Backlog Calculation
Jan	48	35	13	13
Feb	116	102	27	13+14
Mar	23	33	17	-10+27
Apr	65	26	56	39+17
May	50	21	85	29+56
Jun	21	35	71	-14+85
Jul	78	30	119	48+71
Aug	35	42	112	-7+119
Sep	120	96	136	24+112
Oct	45	52	129	-7+136
Nov	60	92	97	-32+129
Dec	75	70	102	5+97

I want to show this data in Bar Chart, but here is one problem. The data I provided is the expected output (using exprtession). I could able to write the expression for "# Opened Request" and "# Closed Request" but I am not able to write expression for BACKLOG column. Backlog is nothing but the reminder or Opened - Closed and addition of previous result to it (I did provided calculation of Backlog for your understanding).

The expressions I used for "# Opened Request" and "# Closed Request" are as below,

"# Opened Request" : sum (Open_Ticket_Count)

"# Closed Request" : sum (Closed_ticket_count)

Can anyone please help me with how can I write expression for "Backlog"?

Thanks in advance.

Regards,

Abhishek

Re: Backlog Calculation for Bar Chart

maxgro — Thu, 16 Jan 2014 13:33:14 GMT

try this expression

=rangesum(Above(sum([# Opened Request]) - sum([# Closed Request]), 0, RowNo()))

if it's what you want I can post the .qvw

Regards

Re: Backlog Calculation for Bar Chart

kiranmanoharrode — Thu, 16 Jan 2014 13:51:02 GMT

Dear Abhishek,

PFA for a Solution...

Regards

Kiran Rode

+91 8976977897

Re: Backlog Calculation for Bar Chart

Thu, 16 Jan 2014 14:26:38 GMT

Thank you guys, it worked well 🙂

Re: Backlog Calculation for Bar Chart

Thu, 16 Jan 2014 14:27:12 GMT

Thanks Kiran

Re: Backlog Calculation for Bar Chart

Thu, 16 Jan 2014 14:27:55 GMT

Thanks Massimo Grossi 🙂