Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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.

2 Replies
Highlighted
Contributor III
Contributor III

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

Highlighted
Champion III
Champion III

Try like:

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