topic Number conversion problem after change from 8.5 to 9 in QlikView https://community.qlik.com/t5/QlikView/Number-conversion-problem-after-change-from-8-5-to-9/m-p/207397#M1284467 <HTML><HEAD></HEAD><BODY><P>Hallo,</P><P>we use an Oracle Database 10g and the oledb driver from Oracle.</P><P>We have a yearweek field like 201008 it was a varchar in oracle.</P><P>I want to extract the week. In QlikView 8.5 I use this function:</P><P></P><P>Right</P><P></P><P>(YEARWEEK, 2)</P><P>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.</P><P>Various other numbers also become a decimal.</P><P>Is this a problem of QlikView? Or is this a conversion problem depending on the english windows?</P><P>regards</P><P></P><P></P><P></P><P>Bastian</P><BR /><BR /> <BR /><BR /> <BR /><BR /></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT btrompetter 2026-01-26T18:19:17Z Number conversion problem after change from 8.5 to 9 https://community.qlik.com/t5/QlikView/Number-conversion-problem-after-change-from-8-5-to-9/m-p/207397#M1284467 <HTML><HEAD></HEAD><BODY><P>Hallo,</P><P>we use an Oracle Database 10g and the oledb driver from Oracle.</P><P>We have a yearweek field like 201008 it was a varchar in oracle.</P><P>I want to extract the week. In QlikView 8.5 I use this function:</P><P></P><P>Right</P><P></P><P>(YEARWEEK, 2)</P><P>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.</P><P>Various other numbers also become a decimal.</P><P>Is this a problem of QlikView? Or is this a conversion problem depending on the english windows?</P><P>regards</P><P></P><P></P><P></P><P>Bastian</P><BR /><BR /> <BR /><BR /> <BR /><BR /></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Number-conversion-problem-after-change-from-8-5-to-9/m-p/207397#M1284467 btrompetter 2026-01-26T18:19:17Z