Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Week Number Format

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.

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Re: Week Number Format

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

View solution in original post

6 Replies
Highlighted
Partner
Partner

Re: Week Number Format

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
Highlighted
Contributor III
Contributor III

Re: Week Number Format

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

Creator III
Creator III

Re: Week Number Format

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

Highlighted
Contributor III
Contributor III

Re: Week Number Format

Hi Mario,

I have done it but it did not change.

Thank you.

Highlighted
Contributor III
Contributor III

Re: Week Number Format

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

View solution in original post

Highlighted