topic Convert Decimal To Hexadecimal in QlikView https://community.qlik.com/t5/QlikView/Convert-Decimal-To-Hexadecimal/m-p/159025#M33837 <HTML><HEAD></HEAD><BODY><P>Works perfect, thanks!</P></BODY></HTML> Thu, 20 May 2010 14:03:11 GMT 2010-05-20T14:03:11Z Convert Decimal To Hexadecimal https://community.qlik.com/t5/QlikView/Convert-Decimal-To-Hexadecimal/m-p/159023#M33835 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I got a problem in converting a minus decimal number into an hexadecimal number.</P><P>Input: -1073741703<BR />Ouput: FFFFFFFFC0000079</P><P>If I'm converting this in the MS Calculator i got the right number, if i use the formula "num(-1073741703), '(HEX)')" i got a 3FFFFF87.</P><P>Maybe someone other has a solution for me?</P><P></P></BODY></HTML> Thu, 20 May 2010 12:47:33 GMT https://community.qlik.com/t5/QlikView/Convert-Decimal-To-Hexadecimal/m-p/159023#M33835 2010-05-20T12:47:33Z Convert Decimal To Hexadecimal https://community.qlik.com/t5/QlikView/Convert-Decimal-To-Hexadecimal/m-p/159024#M33836 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>did not work with a 64 bit number but with 48 bits</P><P>=num(pow(2,48) - 1073741703,'(HEX)')</P><P>Regards</P><P>Jürg</P></BODY></HTML> Thu, 20 May 2010 13:14:21 GMT https://community.qlik.com/t5/QlikView/Convert-Decimal-To-Hexadecimal/m-p/159024#M33836 2010-05-20T13:14:21Z Convert Decimal To Hexadecimal https://community.qlik.com/t5/QlikView/Convert-Decimal-To-Hexadecimal/m-p/159025#M33837 <HTML><HEAD></HEAD><BODY><P>Works perfect, thanks!</P></BODY></HTML> Thu, 20 May 2010 14:03:11 GMT https://community.qlik.com/t5/QlikView/Convert-Decimal-To-Hexadecimal/m-p/159025#M33837 2010-05-20T14:03:11Z