how to change badly formatted numbers when saving to QVD

[Anonymous]

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

[MK_QSL · Accepted solution]

Use Evaluate Function

[jonathandienst]

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,

          ...