topic Re: How to spilt the data in QlikView https://community.qlik.com/t5/QlikView/How-to-spilt-the-data/m-p/39406#M6646 <HTML><HEAD></HEAD><BODY><P>so you should use this:</P><P></P><P><STRONG>purgechar(names,'[]"}') as Name,</STRONG></P><P><SPAN style="font-size: 10pt;"><STRONG>TextBetween( purgechar(names,'[]"}'),'',',') as name2</STRONG></SPAN></P></BODY></HTML> Fri, 02 Mar 2018 11:16:27 GMT YoussefBelloum 2018-03-02T11:16:27Z How to spilt the data https://community.qlik.com/t5/QlikView/How-to-spilt-the-data/m-p/39400#M6640 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>How to spilt the below data&nbsp; in UI level</P><P>sno, names</P><P>1,["Ravi","Niru"]</P><P dir="ltr"><SPAN dir="ltr" style="font-size: 10pt; font-family: 'Segoe UI'; color: #000000;"></SPAN></P><P>2,["Ragu","Nani"}</P><P></P><P>After loading the data in qlikview</P><P></P><P>I am expacted list box level</P><P>List box:</P><P>names</P><P>Ravi</P><P>Niru</P><P>Raghu</P><P>Nani</P><P>i am expacted chart level when ever select "Ravi"</P><P></P><P>Sno,names</P><P>1,Ravi,Niru</P><P></P><P>I&nbsp; expacted above out put . ...</P><P></P><P>Thank!!!!</P></BODY></HTML> Fri, 02 Mar 2018 09:43:33 GMT https://community.qlik.com/t5/QlikView/How-to-spilt-the-data/m-p/39400#M6640 Anonymous 2018-03-02T09:43:33Z Re: How to spilt the data https://community.qlik.com/t5/QlikView/How-to-spilt-the-data/m-p/39401#M6641 <HTML><HEAD></HEAD><BODY><P>Maybe you use the purgechar function : </P><P><A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/StringFunctions/PurgeChar.htm" title="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/StringFunctions/PurgeChar.htm">https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/StringFunctions/PurgeChar.htm</A></P></BODY></HTML> Fri, 02 Mar 2018 10:04:42 GMT https://community.qlik.com/t5/QlikView/How-to-spilt-the-data/m-p/39401#M6641 jaumecf23 2018-03-02T10:04:42Z Re: How to spilt the data https://community.qlik.com/t5/QlikView/How-to-spilt-the-data/m-p/39402#M6642 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try this on the script</P><P></P><P><STRONG>purgechar(SubField(names,','),'[]"}') as Name</STRONG></P></BODY></HTML> Fri, 02 Mar 2018 10:07:51 GMT https://community.qlik.com/t5/QlikView/How-to-spilt-the-data/m-p/39402#M6642 YoussefBelloum 2018-03-02T10:07:51Z Re: How to spilt the data https://community.qlik.com/t5/QlikView/How-to-spilt-the-data/m-p/39403#M6643 <HTML><HEAD></HEAD><BODY><P>‌Try using subfield() like</P><P></P><P>Load sno, subfield(names, ‘,’) As NewName Inline [</P><P>sno, names</P><P>....,.....</P><P>];</P></BODY></HTML> Fri, 02 Mar 2018 10:09:43 GMT https://community.qlik.com/t5/QlikView/How-to-spilt-the-data/m-p/39403#M6643 vishsaggi 2018-03-02T10:09:43Z Re: How to spilt the data https://community.qlik.com/t5/QlikView/How-to-spilt-the-data/m-p/39404#M6644 <HTML><HEAD></HEAD><BODY><P>check it out.</P><P></P><P><IMG alt="1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195153_1.PNG" style="height: auto;" /></P></BODY></HTML> Fri, 02 Mar 2018 11:08:46 GMT https://community.qlik.com/t5/QlikView/How-to-spilt-the-data/m-p/39404#M6644 Qrishna 2018-03-02T11:08:46Z Re: How to spilt the data https://community.qlik.com/t5/QlikView/How-to-spilt-the-data/m-p/39405#M6645 <HTML><HEAD></HEAD><BODY><P>Hi NAgarajuu</P><P></P><P>if I use Subfied in script chart level also spilt the data see my my above expacted output.</P><P></P><P>Thanks you.</P></BODY></HTML> Fri, 02 Mar 2018 11:11:40 GMT https://community.qlik.com/t5/QlikView/How-to-spilt-the-data/m-p/39405#M6645 Anonymous 2018-03-02T11:11:40Z Re: How to spilt the data https://community.qlik.com/t5/QlikView/How-to-spilt-the-data/m-p/39406#M6646 <HTML><HEAD></HEAD><BODY><P>so you should use this:</P><P></P><P><STRONG>purgechar(names,'[]"}') as Name,</STRONG></P><P><SPAN style="font-size: 10pt;"><STRONG>TextBetween( purgechar(names,'[]"}'),'',',') as name2</STRONG></SPAN></P></BODY></HTML> Fri, 02 Mar 2018 11:16:27 GMT https://community.qlik.com/t5/QlikView/How-to-spilt-the-data/m-p/39406#M6646 YoussefBelloum 2018-03-02T11:16:27Z Re: How to spilt the data https://community.qlik.com/t5/QlikView/How-to-spilt-the-data/m-p/39407#M6647 <HTML><HEAD></HEAD><BODY><P>‌uuse concat(distinct names, ‘,’)</P></BODY></HTML> Fri, 02 Mar 2018 12:33:42 GMT https://community.qlik.com/t5/QlikView/How-to-spilt-the-data/m-p/39407#M6647 vishsaggi 2018-03-02T12:33:42Z Re: How to spilt the data https://community.qlik.com/t5/QlikView/How-to-spilt-the-data/m-p/39408#M6648 <HTML><HEAD></HEAD><BODY><P>Hi Krishna ,</P><P>I am looking for UI level not in script level</P></BODY></HTML> Fri, 02 Mar 2018 12:42:48 GMT https://community.qlik.com/t5/QlikView/How-to-spilt-the-data/m-p/39408#M6648 Anonymous 2018-03-02T12:42:48Z