Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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 (2)
0 Replies