topic Re: Difference Between IYYYIW and YYYYWW in QlikView

Difference Between IYYYIW and YYYYWW

rajveersinghsisodiya — Thu, 19 Feb 2015 10:48:40 GMT

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 ?

Re: Difference Between IYYYIW and YYYYWW

AbhijitBansode — Thu, 19 Feb 2015 10:54:04 GMT

to_char() is not a valid QlikView function.

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

Re: Difference Between IYYYIW and YYYYWW

Miguel_Angel_Baeyens — Thu, 19 Feb 2015 11:16:54 GMT

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

Re: Difference Between IYYYIW and YYYYWW

rajveersinghsisodiya — Thu, 19 Feb 2015 12:48:14 GMT

Thanks For Miguel A. Baeyens