topic Set Analysis parameters in QlikView

Set Analysis parameters

richard_chilvers — Tue, 03 Feb 2015 15:33:51 GMT

I admit that set analysis is not my greatest strength.

I have an expression :

SUM({$<WK_BOOKED = {$(#=GetFieldSelections(WK_BOOKED))}, etc......

This works fine to select values where WK_BOOKED is the currently selected week. I'd now like to change it to select values for all weeks up to the currently selected week, ie. weeks 1-(selected week).

I have searched documentation to find how my set might be changed for this.

All help appreciated.

Re: Set Analysis parameters

jpenuliar — Tue, 03 Feb 2015 16:26:00 GMT

Here is a sample SET code for you to wok on:

=count({<Date_In = {'>=$(=date($(vStartDate)))<=$(=date($(vEndDate)))'}>}COUNTER)

essentially, you will have a Date type field, and a Date Range saved in Variables.

Assuming, WK_BOOKED is numeric, Can you try {'<=$(#=GetFieldSelections(WK_BOOKED))'}

Re: Set Analysis parameters

richard_chilvers — Wed, 04 Feb 2015 11:30:23 GMT

Thanks. I've had a quick go with this and it seems to work well, although I need to validate the results.

Regards