topic how to remove NullValues and 0 in QlikView https://community.qlik.com/t5/QlikView/how-to-remove-NullValues-and-0/m-p/306905#M113378 <HTML><HEAD></HEAD><BODY><P>Try this ....</P><P></P><P>=KeepChar(barcode ,123456789)</P><P></P><P></P><P></P><P>Regards,</P><P>Antony</P></BODY></HTML> Wed, 09 Nov 2011 07:49:39 GMT 2011-11-09T07:49:39Z how to remove NullValues and 0 https://community.qlik.com/t5/QlikView/how-to-remove-NullValues-and-0/m-p/306903#M113376 <HTML><HEAD></HEAD><BODY><P>hi all</P><P>i have data like </P><P>barcode</P><P>000001</P><P>0 1012</P><P>00 111</P><P>002222</P><P>000088</P><P> i want to get barcode shown in below format</P><P>barcode</P><P>1</P><P>112</P><P>111</P><P>2222</P><P>88</P><P></P><P>thanks </P><P>rohit</P></BODY></HTML> Wed, 09 Nov 2011 07:39:53 GMT https://community.qlik.com/t5/QlikView/how-to-remove-NullValues-and-0/m-p/306903#M113376 rohit214 2011-11-09T07:39:53Z how to remove NullValues and 0 https://community.qlik.com/t5/QlikView/how-to-remove-NullValues-and-0/m-p/306904#M113377 <HTML><HEAD></HEAD><BODY><P> use thee below code</P><P></P><P></P><P>mid(barcode,findoneof(barcode,'123456789'),len(barcode)-1) as Barcode</P></BODY></HTML> Wed, 09 Nov 2011 07:44:50 GMT https://community.qlik.com/t5/QlikView/how-to-remove-NullValues-and-0/m-p/306904#M113377 SunilChauhan 2011-11-09T07:44:50Z how to remove NullValues and 0 https://community.qlik.com/t5/QlikView/how-to-remove-NullValues-and-0/m-p/306905#M113378 <HTML><HEAD></HEAD><BODY><P>Try this ....</P><P></P><P>=KeepChar(barcode ,123456789)</P><P></P><P></P><P></P><P>Regards,</P><P>Antony</P></BODY></HTML> Wed, 09 Nov 2011 07:49:39 GMT https://community.qlik.com/t5/QlikView/how-to-remove-NullValues-and-0/m-p/306905#M113378 2011-11-09T07:49:39Z how to remove NullValues and 0 https://community.qlik.com/t5/QlikView/how-to-remove-NullValues-and-0/m-p/306906#M113379 <HTML><HEAD></HEAD><BODY><P>hi sunil </P><P>thanks for ur replay</P><P>but it shows like</P><P>barcode</P><P>1</P><P>1012</P><P>111</P><P>2222</P><P>88</P><P>thanks</P><P>rohit</P></BODY></HTML> Wed, 09 Nov 2011 07:50:09 GMT https://community.qlik.com/t5/QlikView/how-to-remove-NullValues-and-0/m-p/306906#M113379 rohit214 2011-11-09T07:50:09Z how to remove NullValues and 0 https://community.qlik.com/t5/QlikView/how-to-remove-NullValues-and-0/m-p/306907#M113380 <HTML><HEAD></HEAD><BODY><P>KeepChar(barcode ,123456789) as barcode</P></BODY></HTML> Wed, 09 Nov 2011 07:51:37 GMT https://community.qlik.com/t5/QlikView/how-to-remove-NullValues-and-0/m-p/306907#M113380 2011-11-09T07:51:37Z