Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to spilt the data

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!!!!

8 Replies
jaumecf23
Creator III
Creator III

YoussefBelloum
Champion
Champion

Hi,

try this on the script

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

vishsaggi
Champion III
Champion III

‌Try using subfield() like

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

sno, names

....,.....

];

krishna_2644
Specialist III
Specialist III

check it out.

1.PNG

Anonymous
Not applicable
Author

Hi NAgarajuu

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

Thanks you.

YoussefBelloum
Champion
Champion

so you should use this:

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

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

vishsaggi
Champion III
Champion III

‌uuse concat(distinct names, ‘,’)

Anonymous
Not applicable
Author

Hi Krishna ,

I am looking for UI level not in script level