Number formatting problem after moving QVW app to new server

[Anonymous]

Hello,

Does anybody have an idea why this is happening.

We are loading data from an Oracle resource. One of the colums is the year age and is defined as number. So the data on Oracle looks like

Year_age

1

2

3

1

5

This data is loaded via ODBC connection into a QVD file.

This QVD file is then loaded into the QVW application.

Now we have a QVW server v11.0.11440.0 and the data in the table and current selection box looks like this:

Which is OK

After moving our application to a new server v11.20.12018.0

the table and current selection box look like this:

A lot of decimal zeros are added to the year.

The year in the table I have fixed after adding some number formatting so the decimals are not displayed anymore.

In the table viewer the number formatting looks also as 1,000000000000

Does anybody has an idea why this is happening on v11.20?

Br,

M

[sushil353]

Hi,

While loading data into qlikview use num() function like Num(Year_age)

HTH

Sushil

[ashfaq_haseeb]

try this

Num(Year_age,'0')

Regards

ASHFAQ

[#4]

Have you checked that the regional settings for the service account which is running the Qlikview services are consistent between your old and new servers?  Also check that the configuration of your Oracle client (and any middleware) are consistent on both servers.

[Anonymous]

Hi All,

Thx for the feedback.

1) The regional settings seems to be OK.

2) when using num(year_age) the problem is solved but I got a strange behaviour.

I use select * from mytable because of a lot of fields I am loading. Then I got for Year_age 1,000000000000000 and much more zeros

When I use select *, num(year_age) from my table the column year_age is suddenly also changed to 1 and the column num(year_age) is also 1.

Is their any explanation for that?

Br,

Mario