topic Re: Week Number Format in QlikView

Week Number Format

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

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 — Fri, 24 Aug 2018 14:38:54 GMT

Hi David.

Try to use this function to lock the weekday:

weekday( DateField , 3)

Anonymous — Fri, 24 Aug 2018 15:28:36 GMT

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 — Fri, 24 Aug 2018 15:47:57 GMT

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 — Fri, 24 Aug 2018 15:59:22 GMT

Hi Mario,

I have done it but it did not change.

Thank you.

Anonymous — Fri, 24 Aug 2018 16:59:03 GMT

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

MarcoWedel — Sun, 26 Aug 2018 20:25:47 GMT