Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Globally set start day of week in an app

Hello,

My week starts on a Sunday and ends Saturday. Is there a way to set the start of week globally in an app to start Sunday ?

I have a requirement to get the week number/ week of month etc for multiple dates and would be better if the Week function works with Sunday start of week instead of Monday ?

Is this even remotely possible in QV ?

I have gone through some of the threads

http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/21/week-start

http://community.qlik.com/thread/52595

But all these suggest writing a script for the master calendar.

Just wanted to get your expert opinion if there is another way around this ?

Thanks,


3 Replies
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

TThe best bet would be to change it in the master calendar.

Not applicable
Author

So are you saying there is no way to ensure the Week function gives us the correct week as per my requirements ?

Not applicable
Author

Hii Lavanyar,

Yes We can do this by going in edit script and set DayNames variable like this:-

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

Please refer to attached image:-

change day start.PNG.png