Week Report

[upaliwije]

Hi Friends

I have developed a pivot table in my QV doc to obtain weekly income figures. Format shown below

But in this report date week date start from Tuesday to Monday whereas I want to show Monday to Sunday. The date range for the above  data is give below for your reference pls.

I have shown current date range and my required range is given in red. My script for master calendar for the above calculation is also shown below.

Kindly help me get my issue corrected. Thanks

[agigliotti]

how does your FirstWeekDay environment variable looks like in script?
in your case it should be equal to 0 (monday).
I hope it helps.

[upaliwije]

Sorry I can't understand what you say . Pls elaborate a little more 

[agigliotti]

try adding the below statement in your script.
SET FirstWeekDay=0;

[upaliwije]

That Part I have already added to my script. Still the result is same

[Brett_Bleess]

Check things against the Help link below, if things are not working as documented, I would submit a support case, but if you are not on the latest service release of the major release you are running, I would recommend trying the latest service release to see if it may work there too:

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Nu...

Regards,
Brett