Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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.

Capture.JPG

Tags (1)
3 Replies
sinanozdemir
Valued Contributor III

Re: 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 da

Hi Ankit,

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

Capture.PNG

sinanozdemir
Valued Contributor III

Re: 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 da

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

Capture.PNG

Thanks

MVP
MVP

Re: 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 da

Please check your script system variable settings for week start:

Redefining the Week Start in Qlik Sense

Redefining the Week Numbers