Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
TThe best bet would be to change it in the master calendar.
So are you saying there is no way to ensure the Week function gives us the correct week as per my requirements ?
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:-