Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

etrotter
Contributor II

Set analysis for this week last year

I think i have the general gist, but its not working for some reason:

Count({<Year={Year(Today())-1}, WeekNum={Week(Today())}>}Station)

I appreciate your help!

1 Solution

Accepted Solutions
MVP
MVP

Re: Set analysis for this week last year

Try by adding the dollar sign expansion

Count({<Year = {"$(=Year(Today())-1)"}, WeekNum = {"$(=Week(Today()))"}>}Station)

1 Reply
MVP
MVP

Re: Set analysis for this week last year

Try by adding the dollar sign expansion

Count({<Year = {"$(=Year(Today())-1)"}, WeekNum = {"$(=Week(Today()))"}>}Station)