topic how to bring data seperately? in QlikView

how to bring data seperately?

diwaskarki — Tue, 16 Jan 2018 04:04:16 GMT

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.

Re: how to bring data seperately?

jonathandienst — Tue, 16 Jan 2018 04:44:27 GMT

This will create one record per DSA:

LOAD

Application,

Entitlement,

[Entitlement Description],

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

FROM ...

Re: how to bring data seperately?

vishsaggi — Tue, 16 Jan 2018 04:49:06 GMT

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

Re: how to bring data seperately?

diwaskarki — Tue, 16 Jan 2018 16:33:57 GMT

Thanks Jonathan.