topic Re: Number formatting problem after moving QVW app to new server in QlikView

Number formatting problem after moving QVW app to new server

Anonymous — Thu, 11 Sep 2014 11:37:40 GMT

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

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,

Re: Number formatting problem after moving QVW app to new server

sushil353 — Thu, 11 Sep 2014 11:42:40 GMT

Hi,

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

HTH

Sushil

Re: Number formatting problem after moving QVW app to new server

ashfaq_haseeb — Thu, 11 Sep 2014 11:48:17 GMT

try this

Num(Year_age,'0')

Regards

ASHFAQ

Re: Number formatting problem after moving QVW app to new server

Thu, 11 Sep 2014 11:52:53 GMT

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.

Re: Number formatting problem after moving QVW app to new server

Anonymous — Thu, 11 Sep 2014 12:41:02 GMT

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