topic set analysis syntax in QlikView

set analysis syntax

Tue, 15 Jul 2014 13:11:51 GMT

Hi!

is there anyway to rewrite the following to be included in set analysis

sum (if([Year Week] = year(today()) & Week(today()-7),

Sales)

i have tried the following without success

sum({<([Year Week] = {'=$(year(today()) & Week(today()-7)'>},

Sales)

Best

Brad

tresB — Tue, 15 Jul 2014 13:16:10 GMT

=sum({<([Year Week] = {'=$( =year(today()) & Week(today()-7)'>} Sales)

Note: added '=' sign and removed comma at the end.

Update: Remove the '(' in red.

avinashelite — Tue, 15 Jul 2014 13:22:36 GMT

Hi Bradley,

Please create a variable to store the current year i.e. year(today())

You cannot use & here, use comma which will act as and function.

and use this variable in the set analysis like below:

sum({<([Year Week] = {'=$(variable) , Week(today()-7)'>}Sales)

Regards,

@vi