topic Re: Values populating in listbox through various excel sheets are different and not in sync? in Qlik Learning Discussions

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

Thu, 15 Jan 2015 10:35:08 GMT

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?

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

m_woolf — Thu, 15 Jan 2015 15:06:30 GMT

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.