
Not applicable
2016-10-05
06:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,
34,442 Views
1 Solution
Accepted Solutions


Specialist
2016-10-06
11:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
5 Replies

Master II
2016-10-06
11:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be try as below:
week( '1971-10-30' ) will returns 43.


Specialist
2016-10-06
11:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi
Week(fecha) = number week
weeknam(fecha) = year & week

Creator
2016-10-06
11:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this one.
=Week (Today ()) will result the current Week Number irrespective of Date.

Not applicable
2016-10-06
11:41 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
There's too many similar posts in this forum, please search before posting this type questions.
To answer this you can try:
- LOAD *,
- Day(Date) as Day,
- WeekDay(Date) as WeekDay,
- Week(Date) as Week,
- WeekName(Date) as WeekName,
- Month(Date) as Month,
- MonthName(Date) as MonthName,
- QuarterName(Date) as QuarterName,
- Year(Date) as Year,
- WeekYear(Date) as WeekYear;
- FROM Table.qvd(qvd);
Hope it helps.
Regards,
Sakir

Creator
2020-06-09
06:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Samir,
Greeting for day, very useful post.
20,173 Views
