topic Re: Hyperlink in a QVD in QlikView

Hyperlink in a QVD

tmumaw — Tue, 08 Apr 2014 12:44:28 GMT

I am reading in a excel file which has a multiple hyperlinks. Based on what the user selects tell me which hyperlink to use. How can I make these hyperlinks within my model? Example : A user might select a office and that office only has 3 hyperlinks and I want the user to be able to click on the hyperlink to display a scanned document.

Re: Hyperlink in a QVD

Tue, 08 Apr 2014 12:54:04 GMT

See the attached QVW.

In the expression we can use the <url> tag. Also be sure to change the Representation option to "Link".

Re: Hyperlink in a QVD

its_anandrjs — Tue, 08 Apr 2014 12:58:48 GMT

Refer this document might be very useful for the URL

Passing Parameters in a URL and Document Chaining

Re: Hyperlink in a QVD

ToniKautto — Tue, 08 Apr 2014 13:08:45 GMT

The hyperlink it self is always stored as a text string in the QlikView data model. Then you can make it clickable in for example a straight table by changing the representation to link, in the chart object's expression settings.

The major consideration you need to make is that the URL is valid for the user clicking it. Meaning that if you for example use a direct file path as URL this must be a valid path from the machine where the end-user clicks the link.

Re: Re: Hyperlink in a QVD

tmumaw — Tue, 08 Apr 2014 13:09:59 GMT

Ken,

Here is what my input looks like. A lot is based on what the user selects as to which hyperlink to use. The column labeled Final Art Link is what I need to use.

Thanks

Re: Hyperlink in a QVD

c_gilbert — Tue, 08 Apr 2014 13:11:52 GMT

I always just use a text object, and add attach an action of 'open URL' to it.

You could then create different text boxes, and change the show condition each one depending on the selection made.

Re: Re: Hyperlink in a QVD

tmumaw — Tue, 08 Apr 2014 13:20:44 GMT

Thanks Ken....works perfect