Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

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?

Tags (1)
1 Reply
mwoolf
Honored Contributor II

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

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.

Community Browser