topic Re: To excludes '00' after BR_CODE in QlikView https://community.qlik.com/t5/QlikView/To-excludes-00-after-BR-CODE/m-p/93239#M15018 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Left(BR_CODE, Len(BR_CODE)-2) as BR_CODE_NEW,</STRONG></P></BODY></HTML> Thu, 28 Jun 2018 16:17:37 GMT sunny_talwar 2018-06-28T16:17:37Z To excludes '00' after BR_CODE https://community.qlik.com/t5/QlikView/To-excludes-00-after-BR-CODE/m-p/93238#M15017 <HTML><HEAD></HEAD><BODY><P>Hi Dear,</P><P></P><P>Please suggest couple of solutions where I may exclude 00 appear after BR_Code.</P><P></P><P>Thanks</P><P></P><P>Neville</P></BODY></HTML> Thu, 28 Jun 2018 16:15:20 GMT https://community.qlik.com/t5/QlikView/To-excludes-00-after-BR-CODE/m-p/93238#M15017 nevilledhamsiri 2018-06-28T16:15:20Z Re: To excludes '00' after BR_CODE https://community.qlik.com/t5/QlikView/To-excludes-00-after-BR-CODE/m-p/93239#M15018 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Left(BR_CODE, Len(BR_CODE)-2) as BR_CODE_NEW,</STRONG></P></BODY></HTML> Thu, 28 Jun 2018 16:17:37 GMT https://community.qlik.com/t5/QlikView/To-excludes-00-after-BR-CODE/m-p/93239#M15018 sunny_talwar 2018-06-28T16:17:37Z Re: To excludes '00' after BR_CODE https://community.qlik.com/t5/QlikView/To-excludes-00-after-BR-CODE/m-p/93240#M15019 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny,</P><P></P><P>It works well.</P><P></P><P>Neville</P></BODY></HTML> Thu, 28 Jun 2018 16:24:49 GMT https://community.qlik.com/t5/QlikView/To-excludes-00-after-BR-CODE/m-p/93240#M15019 nevilledhamsiri 2018-06-28T16:24:49Z