Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Caluation and Set Analysis

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+

    A

    B

    C

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,

2 Replies
chiru_thota
Specialist
Specialist

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  Status0-2930-5960-8990+
    ANew1
    BWorking 1
    CNew 1
   DWorking 1
    E
ashwanin
Specialist
Specialist

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