topic Sql convert decimal format to string (id num) in QlikView https://community.qlik.com/t5/QlikView/Sql-convert-decimal-format-to-string-id-num/m-p/1388060#M613889 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I have field in the format of Decimal.</P><P>The field Is Customer ID. ex: 123123123123123123</P><P>When im extracting him from the Database, he became like this: 1.2223984732987234e+16</P><P>What conversion\format should i amply on the field to set him in the right format? thx.</P></BODY></HTML> Tue, 03 Oct 2017 15:09:21 GMT Xabinav 2017-10-03T15:09:21Z Sql convert decimal format to string (id num) https://community.qlik.com/t5/QlikView/Sql-convert-decimal-format-to-string-id-num/m-p/1388060#M613889 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I have field in the format of Decimal.</P><P>The field Is Customer ID. ex: 123123123123123123</P><P>When im extracting him from the Database, he became like this: 1.2223984732987234e+16</P><P>What conversion\format should i amply on the field to set him in the right format? thx.</P></BODY></HTML> Tue, 03 Oct 2017 15:09:21 GMT https://community.qlik.com/t5/QlikView/Sql-convert-decimal-format-to-string-id-num/m-p/1388060#M613889 Xabinav 2017-10-03T15:09:21Z Re: Sql convert decimal format to string (id num) https://community.qlik.com/t5/QlikView/Sql-convert-decimal-format-to-string-id-num/m-p/1388061#M613890 <HTML><HEAD></HEAD><BODY><P>Hi Adi,</P><P></P><P>Please refer below given solution to this one. Need to check the document override settings. Change the number to integer then it will show properly.</P><P><IMG alt="Adi.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/178452_Adi.png" style="height: 349px; width: 620px;" /></P></BODY></HTML> Tue, 03 Oct 2017 15:24:32 GMT https://community.qlik.com/t5/QlikView/Sql-convert-decimal-format-to-string-id-num/m-p/1388061#M613890 arjakumar 2017-10-03T15:24:32Z Re: Sql convert decimal format to string (id num) https://community.qlik.com/t5/QlikView/Sql-convert-decimal-format-to-string-id-num/m-p/1388062#M613891 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P>Num#(Text([Customer ID])) AS [Customer ID]</P></BODY></HTML> Tue, 03 Oct 2017 15:26:33 GMT https://community.qlik.com/t5/QlikView/Sql-convert-decimal-format-to-string-id-num/m-p/1388062#M613891 vishsaggi 2017-10-03T15:26:33Z