is qlikview capable of handling more than 15 digit no?

[Anonymous]

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.

Eg:

hex code - 291976C005011E34

Expected result – 2961528797062569524

Qlikview result - 296152879706256

Is there any way to convert 15 bit hex to decimal (with 19 digit result)

[kaushiknsolanki]

HI,

     Try this.

     =num(num#('291976C005011E34','(HEX)'),'####################')

     This will give ans till 17 digit.

Regards,

Kaushik Solanki

[antoinelaviron]

Hi,

From what I learned from the last Tech Support Thursdays , the limitation is 17 digits.

Best regards,

Antoine

[#4]

Here is the new Link to the TST:

Tech Support Thursdays