Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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 II

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]

Community Browser