Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set Analysis without variables

Hello all,


I'm trying to create a set analysis equivalent to this expression that I use in a pivot table's expression column:


SUM(

          IF

               (

                    ISSUE_DATE >= SHIPMENT_DATE

                    AND ISSUE_DATE < NEXT_SHIPMENT_DATE

                    AND CHECKED_SHIPMENTS=1,

                    SHIPMENT_VALUE

               )

     )

I've already checked through community a lot but so far I could only found set analysis solutions with variables.
Since I'm not very familiar with set analysis syntax, I couldn't manage to create a working expression.
The expression above works fine but I want to write it as a set analysis expression due to better performance.
In my case ISSUE_DATE, SHIPMENT_DATE and NEXT_SHIPMENT_DATE fields are all in the same date format.
I'd appreciate any help.
Thanks in advance,

1 Reply

Re: Set Analysis without variables

May be something along these lines:

Sum({<ORDERID = {"=ISSUE_DATE >= SHIPMENT_DATE and ISSUE_DATE < NEXT_SHIPMENT_DATE"}, CHECKED_SHIPMENTS = {1}>}SHIPMENT_VALUE)

Replace ORDERID with a field which is unique for a particular combination of ISSUE_DATE, SHIPMENT_DATE and NEXT_SHIPMENT_DATE.

Community Browser