Dynamic Expression Label

Anonymous — Wed, 26 Mar 2014 18:19:27 GMT

Hi,

In my expression label I am trying to create a field name that reflects the specific week number indicated in the expression. My expression is as follows:

SUM({$<Year={$(=Max(Year))},

Period=,

Week=,

[Year Period]=,

[Year Week]=,

Date={">=$(=date(date(vCurrentWeekStart)-91))<=$(=date(date(vCurrentWeekStart)-85))"},

SKU=P(SKU)>} [POS Net Units])

How do I make an expression label that reflects which week the dates specify? I have tried

=Week( Date={">=$(=date(date(vCurrentWeekStart)-91))<=$(=date(date(vCurrentWeekStart)-85))"}) but I haven't had any luck.

Any help would be great!

Re: Dynamic Expression Label

Anonymous — Wed, 26 Mar 2014 18:55:46 GMT

Trying to understand the logic... Look like this will be the label:

week(vCurrentWeekStart-91)

Re: Dynamic Expression Label

Anonymous — Wed, 26 Mar 2014 18:58:38 GMT

Figured it out! Thanks!

topic Dynamic Expression Label in QlikView

Dynamic Expression Label

Re: Dynamic Expression Label

Re: Dynamic Expression Label