topic Calculation in QlikView

Calculation

Tue, 18 Mar 2014 23:55:09 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: Calculation

qlikpahadi07 — Wed, 19 Mar 2014 06:28:48 GMT

You can use Interval match function for the same.

or attach a sample data

Re: Calculation

jonathandienst — Wed, 19 Mar 2014 06:39:55 GMT

You can do it in a table/chart using 4 expressions:

Count(If(Today() - WorkOrderDate < 30, '0-29', WorkOrderNo))

Count(If(Today() - WorkOrderDate >= 30 And Today() - WorkOrderDate < 60, '30-59', WorkOrderNo))

Count(If(Today() - WorkOrderDate >= 60 And Today() - WorkOrderDate < 90, '60-89', WorkOrderNo))

Count(If(Today() - WorkOrderDate >= 90, '90+', WorkOrderNo))

(change the fieldname to match your data model).

This method hard codes the intervals. You could simplify this if in your load, you create a WorkOrderAge field. or interval match the ages.

HTH

Jonathan