Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

inowinowski
New Contributor

Dynamic Expression Label

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!

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Dynamic Expression Label

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

week(vCurrentWeekStart-91)

2 Replies
mov
Esteemed Contributor III

Re: Dynamic Expression Label

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

week(vCurrentWeekStart-91)

inowinowski
New Contributor

Re: Dynamic Expression Label

Figured it out! Thanks!

Community Browser