Discussion Board for collaboration related to QlikView App Development.
How can I supress zeros in an char field?
Example: customer number = 00003212
I want let it as '3312' direct in the script
Go to Solution.
The fastest way is converting it to a number with Num(Field) which will represent the value as as integer in this case.
Num(CustomerNumber) AS CustomerNumber,
Hope that helps.
View solution in original post
You can use Num function
Convert using the Num function.