Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.