Dimension of the last 4 weeks of the current Year

[erwinvullers]

Hi there,

I made a Qlik Sense App last year to get an overview of the time spend on Customers.

the Dimension I created is as follows:

=IF([Week]>=(Week(Today())-4) AND [Week]<=(week(Today())-1) ,[Week])

Now I noticed that this year also data from last year is shown and I cant figure out how to change this formula so it only shows the weeks of the current year.

already thanks for your time and help.

Greetz Erwin. 

[y_grynechko]

Hey, try something like that:

IF([Week] >=(Week(Today())-4) AND [Week] <=(week(Today())-1) ,if(Year(Date) = Year(Today()),[Week], null()) ) 

Year(Date) - replace 'Date' with the name of the field you take dates from.