topic Text value in QlikView https://community.qlik.com/t5/QlikView/Text-value/m-p/1037437#M349574 <HTML><HEAD></HEAD><BODY><P>Hello Dear Experts,</P><P></P><P>i want to get the data to avoiding brackets data on textbox</P><P>i have tried but i'm not able to do it. can some one help me to get the exact answer</P><P></P><P>Textbox = Total Pricing Exception Rate (BCF1542) %,</P><P></P><P>Trying to get out put excluding '(BCF1542)' data</P><P></P><P>Textbox =Total Pricing Exception Rate %</P><P></P><P>Best Regards,</P><P>Niranjan</P></BODY></HTML> Thu, 14 Apr 2016 20:01:27 GMT NavinReddy 2016-04-14T20:01:27Z Text value https://community.qlik.com/t5/QlikView/Text-value/m-p/1037437#M349574 <HTML><HEAD></HEAD><BODY><P>Hello Dear Experts,</P><P></P><P>i want to get the data to avoiding brackets data on textbox</P><P>i have tried but i'm not able to do it. can some one help me to get the exact answer</P><P></P><P>Textbox = Total Pricing Exception Rate (BCF1542) %,</P><P></P><P>Trying to get out put excluding '(BCF1542)' data</P><P></P><P>Textbox =Total Pricing Exception Rate %</P><P></P><P>Best Regards,</P><P>Niranjan</P></BODY></HTML> Thu, 14 Apr 2016 20:01:27 GMT https://community.qlik.com/t5/QlikView/Text-value/m-p/1037437#M349574 NavinReddy 2016-04-14T20:01:27Z Re: Text value https://community.qlik.com/t5/QlikView/Text-value/m-p/1037438#M349575 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=SubField(FieldName, '(', 1)<SPAN style="color: #ff0000;"> &amp; '%'</SPAN></STRONG></P><P></P><P>or may be this:</P><P><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P><STRONG style="font-size: 13.3333px;">=SubField(FieldName, '(', 1) &amp; SubField(FieldName, ')', 2)</STRONG></P></BODY></HTML> Thu, 14 Apr 2016 20:04:11 GMT https://community.qlik.com/t5/QlikView/Text-value/m-p/1037438#M349575 sunny_talwar 2016-04-14T20:04:11Z Re: Text value https://community.qlik.com/t5/QlikView/Text-value/m-p/1037439#M349576 <HTML><HEAD></HEAD><BODY><P>Thank you so muchsunny its working fine </P></BODY></HTML> Thu, 14 Apr 2016 20:14:57 GMT https://community.qlik.com/t5/QlikView/Text-value/m-p/1037439#M349576 NavinReddy 2016-04-14T20:14:57Z