Convert Bigint from MySQL to text in Qlikview

[balanandam]

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

[balanandam · Accepted solution]

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

[Anil_Babu_Samineni]

Great, Please close this thread by flag "correct answer" of your own response..

[sumit_ranjan_pa]

Thats a nice solution!