Hyperlink in a QVD

[tmumaw]

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.

[#2 · Accepted solution]

See the attached QVW.

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

[its_anandrjs]

Refer this document might be very useful for the URL

Passing Parameters in a URL and Document Chaining

[ToniKautto]

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.

[tmumaw]

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

[c_gilbert]

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.

[tmumaw]

Thanks Ken....works perfect