Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
YG
Contributor III
Contributor III

Qlik Sense - Line chart get 2 lines for past 12 week only using dynamic WeekNumbers

Hi Qlikers,

I having a challenge getting this line chart limited for "CurrentWeekNo" - 12 in a lini chart for 2 Financial years 19 and 20

So far I manged to get,

Current week =Replace(WeekName(Today()),'/', '-W')

Last12WeeksNum = Year(today(1))& '-W' & (week(today(1))-12)

 

Below is the Line chart

YG_0-1600241621782.png

 

What i am looking for is how do I get 2 lines FY19 and FY20 asper the given chart just for the period between Currentweek and Last12WeekNum ascending

 

Labels (4)
0 Replies