Set Analysis without variables

Thu, 03 Mar 2016 08:42:10 GMT

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(

(

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,

Re: Set Analysis without variables

sunny_talwar — Thu, 03 Mar 2016 17:59:58 GMT

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.

topic Re: Set Analysis without variables in QlikView

Set Analysis without variables

Re: Set Analysis without variables