Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
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

Tags (3)
16 Replies
Highlighted
Honored Contributor II

Re: Get day number from week

Try weekday(Datefield)

Highlighted
Valued Contributor II

Re: Get day number from week

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

Highlighted
Not applicable

Re: Get day number from week

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

Highlighted
Not applicable

Re: Get day number from week

Thanks but is in a Expression

Highlighted
Valued Contributor II

Re: Get day number from week

Excuse me, but you do you means ?

Martin Favier

Highlighted
Valued Contributor II

Re: Get day number from week

Excuse me, but you do you means ?

Martin Favier

Valued Contributor II

Re: Get day number from week

Excuse me, but you do you means ?

Martin Favier

Highlighted
Not applicable

Re: Get day number from week

I use the script in an expression like

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

Highlighted
Valued Contributor II

Re: Get day number from week

What do you mean by "Dia" ?

Is your expression works ?

Martin Favier