topic Re: Week Report in QlikView

Week Report

upaliwije — Fri, 18 Jan 2019 09:53:30 GMT

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

Re: Week Report

agigliotti — Fri, 18 Jan 2019 10:55:35 GMT

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

Re: Week Report

upaliwije — Fri, 18 Jan 2019 11:14:45 GMT

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

Re: Week Report

agigliotti — Fri, 18 Jan 2019 13:24:49 GMT

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

Re: Week Report

upaliwije — Fri, 18 Jan 2019 14:00:14 GMT

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

Re: Week Report

Brett_Bleess — Thu, 21 Mar 2019 21:24:00 GMT

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/NumberInterpretationVariables/FirstWeekDay.htm

Regards,
Brett