topic Showing String/Subsring in QlikView https://community.qlik.com/t5/QlikView/Showing-String-Subsring/m-p/713813#M256893 <HTML><HEAD></HEAD><BODY><P>Need to show either whole string or substring based on the selection. Below are different scenarios with expected results:</P><P></P><P></P><P>If selected&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Show</P><P>Europe, North America|Europe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Europe</P><P>North America, North America|Europe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; North America</P><P>Europe, North America&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Europe, North America</P><P>Europe, North America|Europe, North America&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Europe, North America</P><P></P><P></P><P>Any ideas.</P></BODY></HTML> Thu, 04 Sep 2014 16:09:27 GMT Anonymous 2014-09-04T16:09:27Z Showing String/Subsring https://community.qlik.com/t5/QlikView/Showing-String-Subsring/m-p/713813#M256893 <HTML><HEAD></HEAD><BODY><P>Need to show either whole string or substring based on the selection. Below are different scenarios with expected results:</P><P></P><P></P><P>If selected&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Show</P><P>Europe, North America|Europe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Europe</P><P>North America, North America|Europe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; North America</P><P>Europe, North America&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Europe, North America</P><P>Europe, North America|Europe, North America&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Europe, North America</P><P></P><P></P><P>Any ideas.</P></BODY></HTML> Thu, 04 Sep 2014 16:09:27 GMT https://community.qlik.com/t5/QlikView/Showing-String-Subsring/m-p/713813#M256893 Anonymous 2014-09-04T16:09:27Z Re: Showing String/Subsring https://community.qlik.com/t5/QlikView/Showing-String-Subsring/m-p/713814#M256894 <HTML><HEAD></HEAD><BODY><P>2 potential solutions attached. Not sure if your actual data is complicated enough to make these fixes insufficient.</P></BODY></HTML> Thu, 04 Sep 2014 17:06:57 GMT https://community.qlik.com/t5/QlikView/Showing-String-Subsring/m-p/713814#M256894 2014-09-04T17:06:57Z Re: Showing String/Subsring https://community.qlik.com/t5/QlikView/Showing-String-Subsring/m-p/713815#M256895 <HTML><HEAD></HEAD><BODY><P>Thank you Clark Kipling, unfortunately, i can't edit the script for it, only changes on front end.</P></BODY></HTML> Thu, 04 Sep 2014 19:07:28 GMT https://community.qlik.com/t5/QlikView/Showing-String-Subsring/m-p/713815#M256895 Anonymous 2014-09-04T19:07:28Z Re: Showing String/Subsring https://community.qlik.com/t5/QlikView/Showing-String-Subsring/m-p/713816#M256896 <HTML><HEAD></HEAD><BODY><P>The second object doesn't require a script change.</P></BODY></HTML> Thu, 04 Sep 2014 19:23:56 GMT https://community.qlik.com/t5/QlikView/Showing-String-Subsring/m-p/713816#M256896 2014-09-04T19:23:56Z