Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
syed_muzammil
Partner - Creator II
Partner - Creator II

How Change the beginning day of a week from Monday to some other Day?

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.

12 Replies
johnw
Champion III
Champion III

That all looks right to me. I'm not sure where it would be going wrong.

Not applicable

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.. Smile



SET

DayNames='Sun;Mon;Tue;Wed;Thu;Fri;Sat';



johnw
Champion III
Champion III


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.. Smile

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.