Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
Showing results for 
Search instead for 
Did you mean: 
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



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