Loading numbers in Qlikview with 17 digits

[Vidya_S15]

Hi All,

From database, we are loading Amount column which has 17 digits before decimal.

Ex: 82945676556743836.7 but in calculation it takes like 82945676556744000. The last 4 digits are rounded off. Could you please let me know how we can load completely and use it in calculation.

Thanks and Regards,

Vidya S

[Or]

In Qlik (as of 2019) Numbers are limited to precision of 15 digits. See: https://community.qlik.com/t5/Knowledge/What-is-the-largest-numeric-value-that-can-be-loaded-in-Qlik...

[marcus_sommer]

Maybe you could bypass this limitation in your use-case with some ideas shared here:

Solved: Re: number of decimals used in floor() function - Qlik Community - 1980322

- Marcus

[PrashantSangle]

Not sure.. dud you try with evaluate ()?

Check evaluate ().. this function might help you

[MarcoWedel]

Just out of curiosity, what kind of amount has this size and this precision?

[Vidya_S15]

@MarcoWedel They used the wrong exchange rate which caused a huge number, but in another entry it was reversed but not with the same value.. the grand total should be 0 , but because of limitation on digits and round off in qlikview we are seeing some difference.