Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get day number from week

Hi I’m struggling getting the number of the day from a week. In a Expression

Example 16/01/2013 is Wednesday that is a 3; a Monday would be a 1 and so on.

Thanks in advance

16 Replies
danielrozental
Master II
Master II

Try weekday(Datefield)

martin59
Specialist II
Specialist II

Hi,

In your load script, use the WeekDay() function.

For example,

LOAD Field1,

     Field2,

     ...,

     DateField,

     Year(DateField) as Year,

     Week(DateField) as Week,

     WeekDay(DateField) as WeekDay,

     Num(WeekDay(DateDield)) as NumWeekDay

FROM Data.qvd (qvd);

Hope that helps you

Martin Favier

Not applicable
Author

Thanks it work well the only other thing that I have to do is modified the script file.

Not applicable
Author

Thanks but is in a Expression

martin59
Specialist II
Specialist II

Excuse me, but you do you means ?

Martin Favier

martin59
Specialist II
Specialist II

Excuse me, but you do you means ?

Martin Favier

martin59
Specialist II
Specialist II

Excuse me, but you do you means ?

Martin Favier

Not applicable
Author

I use the script in an expression like

=if(weekday(today()) = Dia ,Name)

martin59
Specialist II
Specialist II

What do you mean by "Dia" ?

Is your expression works ?

Martin Favier