Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
venkeytcs
Contributor III
Contributor III

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.

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)

3 Replies
kaushiknsolanki
Luminary Alumni
Luminary Alumni

HI,

     Try this.

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

    

     This will give ans till 17 digit.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
antoinelaviron
Partner
Partner

Hi,

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

Best regards,

Antoine

Not applicable

Here is the new Link to the TST:

Tech Support Thursdays