Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
diwaskarki
Contributor II

how to bring data seperately?

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.

dsa report image.pngAs 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.

1 Solution

Accepted Solutions
MVP
MVP

Re: how to bring data seperately?

This will create one record per DSA:

LOAD

  Application,

  Entitlement,

  [Entitlement Description],

  SubField([DSA(s)], ',') As DSA

FROM ...

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
MVP
MVP

Re: how to bring data seperately?

This will create one record per DSA:

LOAD

  Application,

  Entitlement,

  [Entitlement Description],

  SubField([DSA(s)], ',') As DSA

FROM ...

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

vishsaggi
Esteemed Contributor III

Re: how to bring data seperately?

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

diwaskarki
Contributor II

Re: how to bring data seperately?

Thanks Jonathan.