Week 53 issue when comparing with Last Year week

New-Qlik — Mon, 20 Dec 2021 21:05:46 GMT

Hi,

We have a Bar chart dimension is Week Number and Expressions are Sales TY and Sales LY.

now for week 53 we didnt have sales for LY

and for week 1 20201 is getting compared with week 1 2020 but when you see dates its wrong comparison , to get actual result week 1 2021 should get compared with week 2 2020.

Any suggestions

Re: Week 53 issue when comparing with Last Year week

Ksrinivasan — Thu, 28 Jan 2021 18:44:44 GMT

hi,

try this link,

https://help.qlik.com/en-US/sense/November2020/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRecordFunctions/above.htm

you can considered Month as week number

ksrinivasan

topic Week 53 issue when comparing with Last Year week in App Development

Week 53 issue when comparing with Last Year week

Re: Week 53 issue when comparing with Last Year week