Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Not applicable

Nested Set Analysis

I have a problem regarding the Nested Set Analysis below:

DB:

    

WorkOrderIDWorkOrder_DateMachineInstall_Date
WO-1201508Machine1201502
WO-2201509Machine2201503
WO-3201510Machine3201504
WO-4201511Machine4201505
WO-5201512Machine5201506
WO-6201601Machine6201507
WO-7201602Machine7201508
WO-8201603Machine8201509

I need to calculate the Past three Months WorkOrder QTY which  the Machine Install_date must be the Past six Months.

Calculation Condition:  the Machine Install_date must be the Past six Months for WorkOrder.

Please help to provide the expression. Many thanks.

Tags (1)
4 Replies

Re: Nested Set Analysis

What is the expected output for the above sample?

MVP
MVP

Re: Nested Set Analysis

Maybe somthing like

=Count(DISTINCT {<WorkOrderID = {"=AddMonths(Date#(Install_Date,'YYYYMM'),5)<Date#(WorkOrder_Date,'YYYYMM')"}>} WorkOrderID)

Not applicable

Re: Nested Set Analysis

the WorkOrder QTY.

For example:

if I select WorkOrder_date '201603', it need to look whether the Machine Install_date is last 6 six Months, then calculate the past three related WorkOrder QTY.

Not applicable

Re: Nested Set Analysis

Please help to advise whether it need to add the WorkOrder_date. Because I also need to calculate the Past three Months WorkOrder .