Week Number Format

[Anonymous]

Good day everyone.

I want  my week to start from Thursday but I am finding it difficult.

I have attached a sample data.

Note: this one starts on Monday.

Thank you all in advance.

[PabloTrevisan]

Hi David.

Try to use this function to lock the weekday:

weekday( DateField , 3)

• 0 for Monday
• 1 for Tuesday
• 2 for Wednesday
• 3 for Thursday
• 4 for Friday
• 5 for Saturday
• 6 for Sunday

[Anonymous]

Thank you, Pablo. I tried it but it did not work(wrong script) or may be I do not know how to do it.

[MarioCenteno]

Try

t the start of edit script  while defineing varibles

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='Thu;Fri;Sat;Sun;Mon;Tue;Wed';

instead of SETDayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

and save application

[Anonymous]

Hi Mario,

I have done it but it did not change.

Thank you.

[Anonymous · Accepted solution]

Thank you all. I have done it. I have attached the solution.

[MarcoWedel]

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/NumberInterpre...