Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Problem with field connection

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

1 Solution

Accepted Solutions
MVP
MVP

Problem with field connection

[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]
;

5 Replies
Not applicable

Problem with creating a field which should connects right to another field

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

Not applicable

Problem with creating a field which should connects right to another field

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

Not applicable

Problem with field connection

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

MVP
MVP

Problem with field connection

[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]
;

Not applicable

Problem with field connection

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

Regards,

Herbert

Community Browser