topic Re: Calculation help for Wokload???? in QlikView

Calculation help for Wokload????

amit_saini — Fri, 04 Apr 2014 05:32:44 GMT

Hi Folks ,

I'm facing one issue for calculating Workload based on no. of Open and Closed ticket.

I'm having date which is showing ticket status as open as closed . For example for 01/01/2014 I'm having Open=1 and Closed=0 , so work load =1 , similarly on 02/01/2014 I'm having Open =2 , closed =2 , so workload =1 (it should include previous day open ticket in calculation every time).

My Work Load calculation should be opened – closed + running total value from previous day

Please see below :

	Opened	Closed	Work Load
01/01/2014	1	0	1
02/01/2014	2	2	1
03/01/2014	5	1	5
04/01/2014	2	1	6
05/01/2014	0	2	4
06/01/2014	0	4	0
07/01/2014	3	1	2
08/01/2014	3	1	4
09/01/2014	2	1	5
10/01/2014	6	3	8
11/01/2014	1	1	8
12/01/2014	0	1	7
13/01/2014	0	0	7
14/01/2014	1	0	8
15/01/2014	1	2	7

Please help me how to reach to this kind of solution.

Thanks in advance,

Re: Calculation help for Wokload????

Fri, 04 Apr 2014 05:36:42 GMT

HI,

In Pivot chart, write below expression for Work Load:

Rangesum((Opened - Closed),Above([Work Load])

Hote it help

Re: Calculation help for Wokload????

sushil353 — Fri, 04 Apr 2014 05:51:47 GMT

Hi,

If you want to resolve it at script side then try below code:

Table:

load Date,Opened,Closed

,alt(Opened-Closed+Peek(WrokLoad),Opened-Closed) as "WrokLoad"

Inline

[

Date,Opened,Closed

01/01/2014,1,0

02/01/2014,2,2

03/01/2014,5,1

04/01/2014,2,1

05/01/2014,0,2

06/01/2014,0,4

];

HTH

Sushil

Re: Calculation help for Wokload????

amit_saini — Fri, 04 Apr 2014 06:05:28 GMT

Hi Folks,

Here is my application.

Thanks,

Re: Calculation help for Wokload????

MK_QSL — Fri, 04 Apr 2014 06:09:20 GMT

Please check enclosed file showing two solutions...

1) Script End

2) UI end

Hope this helps...

Re: Calculation help for Wokload????

Fri, 04 Apr 2014 06:59:47 GMT

Hi,

try this one

RangeSum((Opened-Closed),Above(TOTAL Sum([Work Load])))

it will work.

Re: Calculation help for Wokload????

amit_saini — Mon, 07 Apr 2014 05:42:46 GMT

Hi Folks,

This is working fine :

RangeSum(above(TOTAL Column(1) -Column(2),0,NoOfRows(TOTAL) ))

Thanks,
AS