Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

adimiz123
New Contributor III

Sql convert decimal format to string (id num)

Hi

I have field in the format of Decimal.

The field Is Customer ID. ex: 123123123123123123

When im extracting him from the Database, he became like this: 1.2223984732987234e+16

What conversion\format should i amply on the field to set him in the right format? thx.

Tags (4)
2 Replies
arjakumar
New Contributor III

Re: Sql convert decimal format to string (id num)

Hi Adi,

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.

Adi.png

vishsaggi
Esteemed Contributor III

Re: Sql convert decimal format to string (id num)

Try like:

Num#(Text([Customer ID])) AS [Customer ID]