Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
nani1990
Contributor
Contributor

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

nani1990
Contributor
Contributor

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, ‘,’)

nani1990
Contributor
Contributor

Hi Krishna ,

I am looking for UI level not in script level