topic Re: Week Start in QlikView

Week Start

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

How to make default week start as Sunday in qlikview.

Thanks..

Anil_Babu_Samineni — Mon, 20 Mar 2017 13:01:23 GMT

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.

sunny_talwar — Mon, 20 Mar 2017 13:17:48 GMT

Look here:

SET FirstWeekDay=6;

nareshthavidishetty — Mon, 20 Mar 2017 14:27:56 GMT

Hi ,

I have used Set FirstWeekDay=6; but is not aking sunday as weekstart.

Attached is the application

Thanks..

sunny_talwar — Mon, 20 Mar 2017 14:41:47 GMT

Which version of QlikView are you using? FirstWeekDay may not be available for older version of QlikView

nareshthavidishetty — Mon, 20 Mar 2017 14:44:35 GMT

Hi ,

Here is the version we are using.

Thanks..

sunny_talwar — Mon, 20 Mar 2017 14:47:13 GMT

See if this thread helps

nareshthavidishetty — Wed, 22 Mar 2017 12:10:07 GMT