Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
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.

Highlighted
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