Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Values populating in listbox through various excel sheets are different and not in sync?

I had few data sources and it  has few data in columns that is more than 15 characters (approx 18). So while loading them I am getting ambiguous values and last 4 digits are different.

For example:

Data in excel sheet is as per below:

-9182910008952620000

After loading in qlikview I am getting below data:

-9182910008952621100

I can't modify the data as it is a legacy data any way around to solve this?

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Only by converting the values to text. Numbers in Qlikview are IEEE 754 floats. See this discussion: Number too large to parse as number?


talk is cheap, supply exceeds demand