How to spilt the data

[Anonymous]

Hi

How to spilt the below data  in UI level

sno, names

1,["Ravi","Niru"]

2,["Ragu","Nani"}

After loading the data in qlikview

I am expacted list box level

List box:

names

Ravi

Niru

Raghu

Nani

i am expacted chart level when ever select "Ravi"

Sno,names

1,Ravi,Niru

I  expacted above out put . ...

Thank!!!!

[jaumecf23]

Maybe you use the purgechar function :

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/StringFunction...

[YoussefBelloum]

Hi,

try this on the script

purgechar(SubField(names,','),'[]"}') as Name

[vishsaggi]

‌Try using subfield() like

Load sno, subfield(names, ‘,’) As NewName Inline [

sno, names

....,.....

];

[Qrishna]

check it out.

[Anonymous]

Hi NAgarajuu

if I use Subfied in script chart level also spilt the data see my my above expacted output.

Thanks you.

[YoussefBelloum]

so you should use this:

purgechar(names,'[]"}') as Name,

TextBetween( purgechar(names,'[]"}'),'',',') as name2

[vishsaggi]

‌uuse concat(distinct names, ‘,’)

[Anonymous]

Hi Krishna ,

I am looking for UI level not in script level