Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
Showing results for 
Search instead for 
Did you mean: 

Reload bigint number from SQL database

We have a document that reloads 300.000.000 records of data from a SQL database. In this table there is a field called MS_ID (Datatype BIGINT).

When i try to reload the complete table something strange happens to the MS_ID. Qlikview changes the format of the number into some strange signs (see also the attachment).

When i try to reload one subset of the table the field MS_ID looks correct, this issue only occurs when i reload the complete table. The MS_ID isn't longer than the maximum of 14 digits.

Any ideas on how to fix this?

Thanks for help

0 Replies