Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to get week number from date in qlik?

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,

1 Solution

Accepted Solutions
el_aprendiz111
Specialist
Specialist

hi

Week(fecha) = number week

weeknam(fecha) = year & week

View solution in original post

5 Replies
trdandamudi
Master II
Master II

May be try as below:

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

el_aprendiz111
Specialist
Specialist

hi

Week(fecha) = number week

weeknam(fecha) = year & week

gopikrishnach
Creator
Creator

Try this one.

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

Not applicable
Author

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
Creator
Creator

Samir,

Greeting for day, very useful post.