Qlik week function is showing one week in advance which is incorrect.Can someone explain how can I substract 1 week from it.I substracted 7as shwon below to get the correct weeks but week 1 is getting counted wrong .Instead of 1 it is counting 53 5 days.

Hi Ankit,

You can use the below expression. I did it in QlikView, but it should work in QlikSense too.

If the above doesn't work, try the below one:

Thanks

Please check your script system variable settings for week start:

Redefining the Week Start in Qlik Sense

Redefining the Week Numbers