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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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