Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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 ?


1 Solution

Accepted Solutions
Highlighted

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

View solution in original post

3 Replies
Highlighted
Specialist
Specialist

to_char() is not a valid QlikView function.

Please refer the help document of your database software in which you are using this function.

Highlighted

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

View solution in original post

Highlighted
Contributor III
Contributor III