topic Problem with field connection in QlikView

Problem with field connection

Wed, 05 Aug 2009 22:46:22 GMT

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

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

Wed, 05 Aug 2009 22:58:56 GMT

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

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

Wed, 05 Aug 2009 23:08:24 GMT

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

Problem with field connection

Thu, 06 Aug 2009 14:51:26 GMT

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

Problem with field connection

johnw — Sat, 08 Aug 2009 05:24:31 GMT

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

Problem with field connection

Mon, 10 Aug 2009 13:31:03 GMT

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

Regards,

Herbert