topic Re: String Expression - Strip Out First Word in QlikView https://community.qlik.com/t5/QlikView/String-Expression-Strip-Out-First-Word/m-p/570505#M1119136 <HTML><HEAD></HEAD><BODY><P>Michael:</P><P>That worked perfectly. Thanks so much.</P><P>Jeff</P></BODY></HTML> Mon, 27 Jan 2014 02:24:58 GMT jmonroe918 2014-01-27T02:24:58Z String Expression - Strip Out First Word https://community.qlik.com/t5/QlikView/String-Expression-Strip-Out-First-Word/m-p/570503#M1119134 <HTML><HEAD></HEAD><BODY><P>Hello:</P><P></P><P>I am using the Cyclic function on a pie chart and I would like to see the label above the legend but not the table name. Example: "CAPA.Status"; I want to only see "Status".</P><P></P><P>This will be the case across several other charts with different names, so I want to apply this to those charts as well.</P><P></P><P>Thanks.</P><P></P><P>Jeff&nbsp; </P></BODY></HTML> Sun, 26 Jan 2014 22:57:48 GMT https://community.qlik.com/t5/QlikView/String-Expression-Strip-Out-First-Word/m-p/570503#M1119134 jmonroe918 2014-01-26T22:57:48Z Re: String Expression - Strip Out First Word https://community.qlik.com/t5/QlikView/String-Expression-Strip-Out-First-Word/m-p/570504#M1119135 <HTML><HEAD></HEAD><BODY><P>In the Label Box put =SubField(GetCurrentField(CycleGroupName),'.',2)</P><P><IMG alt="Image 3.png" class="jive-image" src="/legacyfs/online/52110_Image 3.png" style="width: 620px; height: 550px;" /></P></BODY></HTML> Mon, 27 Jan 2014 00:19:56 GMT https://community.qlik.com/t5/QlikView/String-Expression-Strip-Out-First-Word/m-p/570504#M1119135 Anonymous 2014-01-27T00:19:56Z Re: String Expression - Strip Out First Word https://community.qlik.com/t5/QlikView/String-Expression-Strip-Out-First-Word/m-p/570505#M1119136 <HTML><HEAD></HEAD><BODY><P>Michael:</P><P>That worked perfectly. Thanks so much.</P><P>Jeff</P></BODY></HTML> Mon, 27 Jan 2014 02:24:58 GMT https://community.qlik.com/t5/QlikView/String-Expression-Strip-Out-First-Word/m-p/570505#M1119136 jmonroe918 2014-01-27T02:24:58Z Re: String Expression - Strip Out First Word https://community.qlik.com/t5/QlikView/String-Expression-Strip-Out-First-Word/m-p/570506#M1119137 <HTML><HEAD></HEAD><BODY><P>I think it would be much better if you just renamed the fields properly in the script to start with with. Then you would not have to do this in every object that these fields are used. It would simplify everything in the long run.</P><P></P><P>See more on <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/09/25/how-to-rename-fields" title="http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/25/how-to-rename-fields">http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/25/how-to-rename-fields</A></P><P></P><P>HIC</P></BODY></HTML> Mon, 27 Jan 2014 03:45:38 GMT https://community.qlik.com/t5/QlikView/String-Expression-Strip-Out-First-Word/m-p/570506#M1119137 hic 2014-01-27T03:45:38Z