topic Re: Get day number from week in QlikView https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428880#M487930 <HTML><HEAD></HEAD><BODY><P>Ok sorry !</P><P>If the expression works, have you got another thing to resolve ?</P><P></P><P>Martin Favier</P></BODY></HTML> Wed, 16 Jan 2013 19:13:51 GMT martin59 2013-01-16T19:13:51Z Get day number from week https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428867#M487917 <HTML><HEAD></HEAD><BODY><P><SPAN lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;">Hi I’m struggling getting the number of the day from a week. In a <SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #ffffff;">Expression</SPAN></SPAN></P><P></P><P><SPAN lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;">Example 16/01/2013 is Wednesday that is a 3; a Monday would be a 1 and so on.</SPAN></P><P></P><P><SPAN lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;">Thanks in advance</SPAN></P></BODY></HTML> Wed, 16 Jan 2013 18:10:21 GMT https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428867#M487917 2013-01-16T18:10:21Z Re: Get day number from week https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428868#M487918 <HTML><HEAD></HEAD><BODY><P>Try weekday(Datefield)</P></BODY></HTML> Wed, 16 Jan 2013 18:12:21 GMT https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428868#M487918 danielrozental 2013-01-16T18:12:21Z Re: Get day number from week https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428869#M487919 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In your load script, use the WeekDay() function.</P><P>For example,</P><P></P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD><P>LOAD Field1,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Field2,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ...,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; DateField,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Year(DateField) as Year,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Week(DateField) as Week,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; WeekDay(DateField) as WeekDay,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Num(WeekDay(DateDield)) as NumWeekDay</P><P>FROM Data.qvd (qvd);</P></TD></TR></TBODY></TABLE></BLOCKQUOTE><P>Hope that helps you</P><P></P><P>Martin Favier</P></BODY></HTML> Wed, 16 Jan 2013 18:19:06 GMT https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428869#M487919 martin59 2013-01-16T18:19:06Z Re: Get day number from week https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428870#M487920 <HTML><HEAD></HEAD><BODY><P><SPAN lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;">Thanks it work well the only other thing that I have to do is modified the script file. </SPAN></P></BODY></HTML> Wed, 16 Jan 2013 18:38:45 GMT https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428870#M487920 2013-01-16T18:38:45Z Re: Get day number from week https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428871#M487921 <HTML><HEAD></HEAD><BODY><P>Thanks but is in a Expression</P></BODY></HTML> Wed, 16 Jan 2013 18:39:14 GMT https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428871#M487921 2013-01-16T18:39:14Z Re: Get day number from week https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428872#M487922 <HTML><HEAD></HEAD><BODY><P>Excuse me, but you do you means ?</P><P></P><P>Martin Favier</P></BODY></HTML> Wed, 16 Jan 2013 18:54:44 GMT https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428872#M487922 martin59 2013-01-16T18:54:44Z Re: Get day number from week https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428873#M487923 <HTML><HEAD></HEAD><BODY><P>Excuse me, but you do you means ?</P><P></P><P>Martin Favier</P></BODY></HTML> Wed, 16 Jan 2013 18:54:58 GMT https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428873#M487923 martin59 2013-01-16T18:54:58Z Re: Get day number from week https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428874#M487924 <HTML><HEAD></HEAD><BODY><P>Excuse me, but you do you means ?</P><P></P><P>Martin Favier</P></BODY></HTML> Wed, 16 Jan 2013 18:55:11 GMT https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428874#M487924 martin59 2013-01-16T18:55:11Z Re: Get day number from week https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428875#M487925 <HTML><HEAD></HEAD><BODY><P><SPAN lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;">I use the script in an expression like</SPAN></P><P></P><P><STRONG>=if(weekday(today()) = Dia ,Name)</STRONG></P></BODY></HTML> Wed, 16 Jan 2013 18:57:58 GMT https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428875#M487925 2013-01-16T18:57:58Z Re: Get day number from week https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428876#M487926 <HTML><HEAD></HEAD><BODY><P>What do you mean by "Dia" ?</P><P></P><P>Is your expression works ?</P><P></P><P>Martin Favier</P></BODY></HTML> Wed, 16 Jan 2013 19:08:18 GMT https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428876#M487926 martin59 2013-01-16T19:08:18Z Re: Get day number from week https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428877#M487927 <HTML><HEAD></HEAD><BODY><P>What do you mean by "Dia" ?</P><P></P><P>Is your expression works ?</P><P></P><P>Martin Favier</P></BODY></HTML> Wed, 16 Jan 2013 19:08:28 GMT https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428877#M487927 martin59 2013-01-16T19:08:28Z Re: Get day number from week https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428878#M487928 <HTML><HEAD></HEAD><BODY><P>What do you mean by "Dia" ?</P><P></P><P>Is your expression works ?</P><P></P><P>Martin Favier</P></BODY></HTML> Wed, 16 Jan 2013 19:08:44 GMT https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428878#M487928 martin59 2013-01-16T19:08:44Z Re: Get day number from week https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428879#M487929 <HTML><HEAD></HEAD><BODY><P><SPAN lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;">“Dia” means Day in Spanish and is a DB field, yes the expression works. </SPAN></P></BODY></HTML> Wed, 16 Jan 2013 19:10:15 GMT https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428879#M487929 2013-01-16T19:10:15Z Re: Get day number from week https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428880#M487930 <HTML><HEAD></HEAD><BODY><P>Ok sorry !</P><P>If the expression works, have you got another thing to resolve ?</P><P></P><P>Martin Favier</P></BODY></HTML> Wed, 16 Jan 2013 19:13:51 GMT https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428880#M487930 martin59 2013-01-16T19:13:51Z Re: Get day number from week https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428881#M487931 <HTML><HEAD></HEAD><BODY><P>Ok sorry !</P><P>If the expression works, have you got another thing to resolve ?</P><P></P><P>Martin Favier</P></BODY></HTML> Wed, 16 Jan 2013 19:14:03 GMT https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428881#M487931 martin59 2013-01-16T19:14:03Z Re: Get day number from week https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428882#M487932 <HTML><HEAD></HEAD><BODY><P>Ok sorry !</P><P>If the expression works, have you got another thing to resolve ?</P><P></P><P>Martin Favier</P></BODY></HTML> Wed, 16 Jan 2013 19:14:18 GMT https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428882#M487932 martin59 2013-01-16T19:14:18Z Re: Get day number from week https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428883#M487933 <HTML><HEAD></HEAD><BODY><P>Could you test:</P><P></P><P><EM>Num(WeekDay(Today()))</EM></P><P></P><P>0 - Monday</P><P>1 - Tuesday</P><P>...</P><P>6 - Sunday</P></BODY></HTML> Mon, 19 Feb 2018 13:20:59 GMT https://community.qlik.com/t5/QlikView/Get-day-number-from-week/m-p/428883#M487933 helder_tack 2018-02-19T13:20:59Z