topic Re: Caluation and Set Analysis in QlikView

Caluation and Set Analysis

Wed, 19 Mar 2014 02:04:19 GMT

I have a set of work orders that are broken down into the following categories:

Age of the Work Orders by Trades

Trade 0-29 30-59 60-89 90+

The work orders can have various status but what I would like is a count of work orders in each of the 4 groups based on total new, and working. The other item is I only want work days which I believe is use the networkdays command.

Any help would be grateful.

Thanks,

Re: Caluation and Set Analysis

chiru_thota — Wed, 19 Mar 2014 02:23:25 GMT

I assuming your data as below.If yes you can write

sum({<Status={'New','Working'}>}0-29) + sum({<Status={'New','Working'}>}30-59) +

sum({<Status={'New','Working'}>}30-59) + sum({<Status={'New','Working'}>}90+)

Trade	Status	0-29	30-59	60-89	90+
A	New	1
B	Working		1
C	New			1
D	Working				1
E

Re: Caluation and Set Analysis

ashwanin — Wed, 19 Mar 2014 07:10:03 GMT

Can you post a sample?

Bz what i believe, you have to do aging of workorders and then have to segregate the same as new and working