topic Re: how to change badly formatted numbers when saving to QVD in QlikView

how to change badly formatted numbers when saving to QVD

Anonymous — Fri, 14 Aug 2015 08:19:03 GMT

Hi everyone,

I have a certain column Im saving to a qvd. the column name is card_no and it consists of a length of 16 numbers.

for example: car_no = 1234567891234567

now when Im saving this column to a qvd, the qvd sees the column as 1.23456789123e+567 for example.

How could I change this so the qvd reads in the correct number and not this weirdly formatted number?

thanks

Stefan

Re: how to change badly formatted numbers when saving to QVD

MK_QSL — Fri, 14 Aug 2015 08:22:46 GMT

Use Evaluate Function

Re: how to change badly formatted numbers when saving to QVD

jonathandienst — Fri, 14 Aug 2015 08:30:35 GMT

That would be 1.23456789123E16 surely? Anyway, Qlikview integers can be up to 13 characters, so if a 16 digit number is read in QV will convert it to an exponential of the form above.

Make sure that whenever you read that number you do something like this - especially when you first read from the source:

LOAD ...

text(car_no) As car_no,

...