how to get week number from date in qlik?

[#1]

Hi All,

I am new to Qlik, try to achieve week number from date field.

tried with below formula and its gave wrong result, please advise.

     WeekName(Date,0,-1) as week_no,

[trdandamudi]

May be try as below:

week( '1971-10-30' )  will returns 43.

[el_aprendiz111 · Accepted solution]

hi

Week(fecha) = number week

weeknam(fecha) = year & week

[gopikrishnach]

Try this one.

=Week (Today ()) will result the current Week Number irrespective of Date.

[#5]

Hi,

There's too many similar posts in this forum, please search before posting this type questions.

To answer this you can try:

1. LOAD *, 
2.     Day(Date) as Day, 
3.     WeekDay(Date) as WeekDay,    
4.     Week(Date) as Week, 
5.     WeekName(Date) as WeekName, 
6.     Month(Date) as Month, 
7.     MonthName(Date) as MonthName, 
8.     QuarterName(Date) as QuarterName, 
9.     Year(Date) as Year, 
10.     WeekYear(Date) as WeekYear;
11. FROM Table.qvd(qvd);

Hope it helps.

Regards,

Sakir

[Sagar082]

Samir,

Greeting for day, very useful post.