Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.