topic The smart way for boolean filter with Set Analysis in QlikView

The smart way for boolean filter with Set Analysis

Fri, 02 Sep 2011 09:02:52 GMT

Is there a smarter way than this?

SUM({<DSS_DATE.IS_WEEKDAY={"-1"} >} DSS_INVENTORY.OUT_OF_STK_STATE)

Like:

SUM({<DSS_DATE.IS_WEEKDAY={"=true()"} >} DSS_INVENTORY.OUT_OF_STK_STATE)

swuehl — Fri, 02 Sep 2011 10:03:15 GMT

You need a dollar sign expansion with function calls inside the set expression, maybe like this:

SUM({<DSS_DATE.IS_WEEKDAY={'$(=true())'} >} DSS_INVENTORY.OUT_OF_STK_STATE)

Stefan

Fri, 02 Sep 2011 12:59:23 GMT

Hi uweh,

what about this:

SUM( if(DSS_DATE.IS_WEEKDAY, DSS_INVENTORY.OUT_OF_STK_STATE, 0))

Regards, Roland

Anonymous — Fri, 02 Sep 2011 13:16:31 GMT

Agree with Roland that it is smarter without set analysis:

sum(DSS_INVENTORY.OUT_OF_STK_STATE * fabs(DSS_DATE.IS_WEEKDAY))

Regards,

Michael