Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN 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
m_woolf
Master II
Master II

You haven't said what this data is, so here is a wild guess.

Excel is treating this data as a number and is rounding.

QV reads the number and displays rounded differently.

Perhaps converting the number in Excel to a label and then reading into QV as a string?

Some sample Excel data might help resolve this issue.