0 Replies Latest reply: Jul 9, 2010 8:27 AM by Bastian Trompetter RSS

    Number conversion problem after change from 8.5 to 9

    Bastian Trompetter

      Hallo,

      we use an Oracle Database 10g and the oledb driver from Oracle.

      We have a yearweek field like 201008 it was a varchar in oracle.

      I want to extract the week. In QlikView 8.5 I use this function:

       

      Right

       

      (YEARWEEK, 2)

      After a change from 8.5 to 9 SR4 and german windows to english windows all weeks are 00 because the YEARWEEK become 201008,00.

      Various other numbers also become a decimal.

      Is this a problem of QlikView? Or is this a conversion problem depending on the english windows?

      regards

       

       

       

      Bastian