Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have data as below
7042394432384812206
1664224432861982307
6125752568775895263
8430717576788538022
1521929941711170694
6381227051209150169
620597394589890750
but when I add this column in qlikview report it converts to floating values
Pls. suggest.
Thanks in Advance!
Balanandam
Hi All,
it must be CHAR format instead BIGINT, but you all know how does this change impacts on Production database. So, time being, I did this below
LOAD
SerialNumber;
SQL SELECT CAST(SerialNumber AS CHAR) from table;
Convert to CHAR before loading into Qlikview that solves my problem ....
Thanks!
Balanandam
Great, Please close this thread by flag "correct answer" of your own response..
Thats a nice solution!