Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Number Format problems with OLEDB Connection


i have a problem with publishing my qlikview documents with qv server.

If I reload the file with qlikview server with a direct connection to an oracle database (oledb) the number format is like 1,0000000000000000000000 (bad)

If I reload the file with my local  client and an odbc connection the number format is correct an the flag is 1 (correct).

The problem is that i use formulas with set analysis ={1} which is not usable with the incorrect number format.

The format type of the column in the oracle database is "number"

Thank you very much for your help!!!!

kind regards


1 Reply
Not applicable

Re: Number Format problems with OLEDB Connection

Steffen - I am also dealing with this problem now.  One thing that works is to use cast(<number> as int) when the number is an integer.

Dealing with decimals is giving a bit of a problem.  the Oracle round() and trunc() functions don't seem to work when that code is passed through via OLEDB.

So if you just have integers, simply cast those as integers in the script and you'll be fine.