topic Set Analysis in QlikView

Set Analysis

Tue, 30 Apr 2013 13:10:13 GMT

When using below Variable, the expression returns a value only if the dimension KEY_FORECAST_WEEK_PROG is selected with a unique value.

As soon as several values or no value is selected, the chart can not any more display the below variable.

Sum({$<KEY_FORECAST_WEEK_PROG={"<=$(=KEY_CALENDAR_WEEK_PROG)"},KEY_FORECAST_WEEK_PROG={">=$(=KEY_CALENDAR_WEEK_PROG-3)"}>}

NET_BILLING_VAL_D)/UnitConstant

Any help is welcome

Thanks Ahead

Gilles

Re: Set Analysis

Tue, 30 Apr 2013 13:18:16 GMT

try this

Sum({1<KEY_FORECAST_WEEK_PROG={"<=$(=KEY_CALENDAR_WEEK_PROG)"},KEY_FORECAST_WEEK_PROG={">=$(=KEY_CALENDAR_WEEK_PROG-3)"}>}

NET_BILLING_VAL_D)/UnitConstant

Re: Set Analysis

swuehl — Tue, 30 Apr 2013 13:21:58 GMT

In general, you shouldn't use multiple field selection modifier for the same field (KEY_FORECAST_WEEK_PROG) in the same set expression. Instead, use an advanced search expression that combines your sets:

Sum({$<KEY_FORECAST_WEEK_PROG={">=$(=KEY_CALENDAR_WEEK_PROG-3)<=$(=KEY_CALENDAR_WEEK_PROG)"} >}

NET_BILLING_VAL_D)/UnitConstant