topic Exponential data issue in QlikView

Exponential data issue

Wed, 13 Aug 2014 10:00:01 GMT

Hi All,

Our data source is DB2 and we have created all the necessary qvd.

While validating the values, we realised that the a Primary Key which is 20 digit long is converted into exponential format while creating the QVD file because of which we are getting wrong values.

Is there any way by which we can get rid of this auto conversion of numeric data into exponential data while creating the qvd ?

eg:

Value in DB2: 10203040506070801020

Value in QVD; 102 e+17

Re: Exponential data issue

kaushiknsolanki — Wed, 13 Aug 2014 10:04:13 GMT

HI,

Generally QlikView takes data as it is.

Kindly convert the field from number to text in DB and then try.

Regards,

Kaushik Solanki

Re: Exponential data issue

tresB — Wed, 13 Aug 2014 10:05:58 GMT

Try using text(), like:

Text(Value) as NumInText

then for any calculation on this field use like : =evaluate(NumInText)+10

Re: Exponential data issue

jagan — Wed, 13 Aug 2014 10:11:15 GMT

Hi,

If you are not using this for calculation simply use

Data:

LOAD

Text(Value) AS Value_Text

FROM DataSource;

Hope this help you.

Regards,

Jagan.