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