Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

diwaskarki
Not applicable

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
jontydkpi
Not applicable

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
3 Replies
jontydkpi
Not applicable

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
vishsaggi
Not applicable

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

Re: how to bring data seperately?

Thanks Jonathan.