Problem with field connection

[#1]

Hi,

I hope somebody could help me. I think to understand my problem please use me .qvw file

Problem how to get the Issuetype of the Links
This is a Testapplication. I have loaded the data into QlikView, than I have created a subfield "Issuelinks" to seperate the link entries. All the Issues are connected in a special way and I want to show these connections.

Problem in Detail:
Now I have the Problem that I don't know what Issue Type the Issue Links are. For example TST-1 should be 'CR'.
I want to do this within the script.

For solutions please use my .qvw file. Thank you very much.

Regards,

Herbert

[#2]

I don't see you qvw file. Did you published it ?

[#3]

Hi,

Sorry, I tried 10 times now to upload it to the Qlik Forum, I always got an error. Now it was working. Sorry for that!

Regards,

Herbert

[#4]

Hi,

If you need further information about my problem please let me know so I could explain it in a better way. I hope I get some help here.

Regards,

Herbert

[johnw · Accepted solution]

[Data]:
LOAD
"Issue Type"
,"Key"
,"Summary"
,ltrim(subfield("Issue Links", '.')) as "Issue Link"
INLINE [Issue Type, Key, Summary, Issue Links
Bug, TST-9, Bug QlikView,
Task, TST-8, Task Jira,
Task, TST-7, Task QlikView, TST-2
Bug, TST-6, Bug Ablöse MKS, TST-1
Bug, TST-5, Bug Jira, TST-4
Bug, TST-4, Bug QlikView, TST-5. TST-2
CR, TST-3, Bug Tracking Jira,
CR, TST-2, QlikView, TST-4. TST-7
CR, TST-1, Ablöse MKS, TST-6
];
LEFT JOIN ([Data])
LOAD
"Key" as "Issue Link"
,"Issue Type" as "Issue Link Type"
RESIDENT [Data]
;

[#6]

Thank you I tested the solution that works fine for me! Everything is Ok!

Regards,

Herbert