Hi,
I have a Qlik Sense app that compares the sales this year and last year. I'm using a calendar that has Date, Week, Month etc... So I thought i would make sense to use Date field to filter data for this year and Addyears(Date, -1) for previous year.
Its works perfectly for date range selection but if we select a "Week range" its picks the corresponding date range which is alright for this year but the previous year's week range is not same as this year's week range as the 'Day' last year will not be the same as day this year.
ex: if today is Monday, last year today could be Sunday which means if today is week no. 32 last year same day would be week no. 31.
Is there a way to get the same weeks data when weeks are selected?
Thanks
