Skip to main content
Announcements
Product Release Webinar: Qlik Insider airing December 6! REGISTER TODAY!
cancel
Showing results for 
Search instead for 
Did you mean: 
balanandam
Creator II
Creator II

Convert Bigint from MySQL to text in Qlikview

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

12 Replies
balanandam
Creator II
Creator II
Author

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..

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sumit_ranjan_pa
Former Employee
Former Employee

Thats a nice solution!