Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
diwaskarki
Creator II
Creator 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
jonathandienst
Partner - Champion III
Partner - Champion III

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
jonathandienst
Partner - Champion III
Partner - Champion III

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

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
Creator II
Creator II
Author

Thanks Jonathan.