is qlikview capable of handling more than 15 digit no?
I am trying to convert 16 digit HEX value to Decimal – to make it primary key and to link it with another table, which contains the decimal value.
But, I’m facing issue with the Digits. I should get 19 digit decimal value if I’m converting the 16 bit HEX. By default, Qlikview is processing only till first 15 digits and is truncating last 4 digits (and I guess, Qlikview can handle only till 15 digit calculation and not more than that).
I have tried with the Qlikview Hex –Dec conversion functionally, Macro and using direct mathematical calculation. Everything is able to convert only till 15 digits.
hex code - 291976C005011E34
Expected result – 2961528797062569524
Qlikview result - 296152879706256
Is there any way to convert 15 bit hex to decimal (with 19 digit result)