Discussion Board for collaboration on QlikView Scripting.
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.
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.
Num#(Text([Customer ID])) AS [Customer ID]