Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
rcandeo
Contributor III

supress zeros

How can I supress zeros in an char field?

Example: customer number = 00003212

I want let it as '3312' direct in the script

1 Solution

Accepted Solutions

supress zeros

Hello Robson,

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

3 Replies

supress zeros

Hello Robson,

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

Highlighted
deepakk
Valued Contributor III

supress zeros

hi Robson,

You can use Num function

num(Customer number)

Not applicable

supress zeros

Convert using the Num function.