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 YG_0-1600241621782.png](https://community.qlik.com/t5/image/serverpage/image-id/40627iB72E74A2CD275339/image-size/medium?v=v2&px=400)
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