Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!!
Maybe you use the purgechar function :
Hi,
try this on the script
purgechar(SubField(names,','),'[]"}') as Name
Try using subfield() like
Load sno, subfield(names, ‘,’) As NewName Inline [
sno, names
....,.....
];
check it out.
Hi NAgarajuu
if I use Subfied in script chart level also spilt the data see my my above expacted output.
Thanks you.
so you should use this:
purgechar(names,'[]"}') as Name,
TextBetween( purgechar(names,'[]"}'),'',',') as name2
uuse concat(distinct names, ‘,’)
Hi Krishna ,
I am looking for UI level not in script level