Integration of Qlikview App with OTRS Helpdesk

[#1]

Dear All,

I am working on a BI application which showing details of OTRS open source helpdesk data of a client. There is a requirement to configure qlikview application in such a way that when user clicks on hyperlink of a specific ticket number on BI application, he should be redirected to OTRS potal to show entire details of that ticket. This otrs potal is published with specific id i.e https://192.168.200.143

If any one has any idea to do this ,please help me on urgent basis.

Thanks in Advance

Regards

Hari Prasad

[Gysbert_Wassenaar]

In a straight table you can set the representation of an expression to Link so it will act as a hyperlink if the expression returns a string value like'Text_shown_as_link_here<url>http://somesite.org/ticket=1234' . If you use TicketID as dimension you could use as expression something like:

     =TicketID & '<url>https://192.126.200.143/ticket_id=' & TicketID.

I don't know OTRS so I don't know the correct url that will retrieve a page with the details of a ticket.