Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
rohit214
Creator III
Creator III

how to remove NullValues and 0

hi all

i have data like

barcode

000001

0 1012

00 111

002222

000088

i want to get barcode shown in below format

barcode

1

112

111

2222

88

thanks

rohit

1 Solution

Accepted Solutions
Not applicable

Try this ....

=KeepChar(barcode ,123456789)

Regards,

Antony

View solution in original post

4 Replies
SunilChauhan
Champion II
Champion II

use thee below code

mid(barcode,findoneof(barcode,'123456789'),len(barcode)-1) as Barcode

Sunil Chauhan
Not applicable

Try this ....

=KeepChar(barcode ,123456789)

Regards,

Antony

rohit214
Creator III
Creator III
Author

hi sunil

thanks for ur replay

but it shows like

barcode

1

1012

111

2222

88

thanks

rohit

Not applicable

KeepChar(barcode ,123456789) as barcode