Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
In Qlikview the week begins on Monday.Is there any shorter way to start the week from Saturday or any other day?
Thanks All.
That all looks right to me. I'm not sure where it would be going wrong.
Hi,
I changed the order of the DayNames in the document settings of my script and it worked well for me. Hopefully this helps someone. See below..
SET
DayNames='Sun;Mon;Tue;Wed;Thu;Fri;Sat';
talleyrobyn wrote:Hi, I changed the order of the DayNames in the document settings of my script and it worked well for me. Hopefully this helps someone. See below..
SET DayNames='Sun;Mon;Tue;Wed;Thu;Fri;Sat';
VERY bad idea. Your weeks might look like they start with Sunday, but that's because you're calling Monday Sunday. See attached. April 4 is not Sunday as displayed in the first column, it's Monday. We can see this in the second column. Likewise, if we use the weekstart() function on our date, our weeks still start on Mondays - March 28, April 4, etc.