topic Re: Substring in chart in QlikView https://community.qlik.com/t5/QlikView/Substring-in-chart/m-p/1283889#M865656 <HTML><HEAD></HEAD><BODY><P>May be use the Dual function:</P><P><A href="https://community.qlik.com/docs/DOC-8106">How to use- Dual()</A></P></BODY></HTML> Mon, 19 Dec 2016 14:49:56 GMT sunny_talwar 2016-12-19T14:49:56Z Substring in chart https://community.qlik.com/t5/QlikView/Substring-in-chart/m-p/1283888#M865655 <HTML><HEAD></HEAD><BODY><P>Hi and sorry for my poor english,</P><P></P><P>I wonder if there is a way to make a substring for data which are displayed in a Chart,</P><P></P><P>Example, I have :</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">dimension</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>expression</STRONG></TH></TR><TR><TD style="padding: 2px;">50 - Bla1</TD><TD style="padding: 2px;">448648</TD></TR><TR><TD style="padding: 2px;">100 - Waa2</TD><TD style="padding: 2px;">757454</TD></TR><TR><TD style="padding: 2px;">150 - Aga3 </TD><TD style="padding: 2px;">848848</TD></TR><TR><TD style="padding: 2px;">200 - kla4</TD><TD style="padding: 2px;">584854</TD></TR></TBODY></TABLE><P></P><P>I use 50-, 100-, 150- and 200- only to sort the dimension used in a bar chart, how can I have only Bla1, Waa2, Aga3 and kla4 displayed in the chart but with the good order ?</P><P></P><P>Using the XXX - Label pattern works but it's not elegant. (50-, 100-, 150- ... are present in another field)</P><P></P><P>Thanks in advance.</P><P></P><P>Christophe</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Substring-in-chart/m-p/1283888#M865655 2020-11-25T16:16:04Z Re: Substring in chart https://community.qlik.com/t5/QlikView/Substring-in-chart/m-p/1283889#M865656 <HTML><HEAD></HEAD><BODY><P>May be use the Dual function:</P><P><A href="https://community.qlik.com/docs/DOC-8106">How to use- Dual()</A></P></BODY></HTML> Mon, 19 Dec 2016 14:49:56 GMT https://community.qlik.com/t5/QlikView/Substring-in-chart/m-p/1283889#M865656 sunny_talwar 2016-12-19T14:49:56Z Re: Substring in chart https://community.qlik.com/t5/QlikView/Substring-in-chart/m-p/1283890#M865657 <HTML><HEAD></HEAD><BODY><P>you may use subfield in caclulated dimension</P><P></P><P>e.g. in textobject: <SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">SubField</SPAN><SPAN style="font-size: 8pt;">('50 - Bla1', '-', 2) </SPAN> gives you Bla1</P></BODY></HTML> Mon, 19 Dec 2016 14:52:49 GMT https://community.qlik.com/t5/QlikView/Substring-in-chart/m-p/1283890#M865657 Anonymous 2016-12-19T14:52:49Z Re: Substring in chart https://community.qlik.com/t5/QlikView/Substring-in-chart/m-p/1283891#M865658 <HTML><HEAD></HEAD><BODY><P>Wonderful, It works for me ! Thank you!</P></BODY></HTML> Mon, 19 Dec 2016 15:10:46 GMT https://community.qlik.com/t5/QlikView/Substring-in-chart/m-p/1283891#M865658 2016-12-19T15:10:46Z