Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to change badly formatted numbers when saving to QVD

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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Use Evaluate Function

View solution in original post

2 Replies
MK_QSL
MVP
MVP

Use Evaluate Function

jonathandienst
Partner - Champion III
Partner - Champion III

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,

          ...



Logic will get you from a to b. Imagination will take you everywhere. - A Einstein