

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Difference Between IYYYIW and YYYYWW
Hi,
what is difference between to_char(START_DATE + 1,'IYYYIW') and to_char(START_DATE + 1,'YYYYWW').
because when i have used first expression it will give like 201508 and second one will give 201507.
Please explain how IYYYIW is different from YYYYWW ?
Accepted Solutions
.png)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Abhijit Bansodeis right. These are not QlikView or Qlik Sense functions.
If you are talking about Oracle to_char(), there are important differences:
IYYY format uses the ISO standard and IW returns the week of the year from 1 to 53 based on the ISO, while WW returns a value between 1 and 52 (see Format Models from the Oracle Docs reference).
They are similar to what you can achieve using Week() and YearWeek() in QlikView (Redefining the Week Numbers by Henric Cronström is a must)
Miguel


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
to_char() is not a valid QlikView function.
Please refer the help document of your database software in which you are using this function.
.png)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Abhijit Bansodeis right. These are not QlikView or Qlik Sense functions.
If you are talking about Oracle to_char(), there are important differences:
IYYY format uses the ISO standard and IW returns the week of the year from 1 to 53 based on the ISO, while WW returns a value between 1 and 52 (see Format Models from the Oracle Docs reference).
They are similar to what you can achieve using Week() and YearWeek() in QlikView (Redefining the Week Numbers by Henric Cronström is a must)
Miguel


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks For Miguel A. Baeyens
