Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to make default week start as Sunday in qlikview.
Thanks..
you can change the order of
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Sun;Mon;Tue;Wed;Thu;Fri;Sat';
instead of SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
and save application and reload. It Should start from Sunday only.
Look here:
SET FirstWeekDay=6;
Hi ,
I have used Set FirstWeekDay=6; but is not aking sunday as weekstart.
Attached is the application
Thanks..
Which version of QlikView are you using? FirstWeekDay may not be available for older version of QlikView
Hi ,
Here is the version we are using.
Thanks..
See if this thread helps
Please check Week numbers not correct