Discussion Board for collaboration on QlikView Scripting.
I have a straight table and a list box. Data in the straight table is displayed according to the filter in the list box. Below is a snapshot.
As you can see in the Master DSA List straight table, I have multiple DSAs in the same row.
This is my script to bring in the DSA.
TextBetween(Replace(Replace(Replace(Replace(ATTRIBUTES, chr(10), ''), ' ', ''), '<String>', ''), '</String>', ','), '<entrykey="SFGROUPOWNER"><value><List>', '</List>') As MAGroupOwners,
MAGroupOwners is renamed as DSA.
What can I do in the script to bring each MAGroupOwners separately in each row? Also, how can I do the same thing in the straight chart? I would really appreciate the help.
Go to Solution.
This will create one record per DSA:
SubField([DSA(s)], ',') As DSA
View solution in original post
You mean you want those comma separated values as separate rows? Eg. JLIO, LU5B? May be use
Subfield() Function around your textybetween like
Subfield(textbetween(Replace....)), ',')) AS MAGroupOwners