Make Column Data into Clickable HTML Link?

[raynac]

I am importing a table into a view where one of the columns contains an HTML address.

It imports, of course, as text, but I am being asked to make that data "clickable" so that the owner here can click on whichever link he wants and be brought straight to the document in question.

Is this something that can be done?  I have tried the a href tags and such and all that does is print the a href info in the field.

If it matters, we are currently using Qlikview 8.5 but I could probably upgrade if it made a difference.

Thanks in advance,

Rayna

[Anonymous]

Ryana,

You can use expression with representation "Link".  Expression itself is like this:

=<string expression which will be shown in cell as text> & '<URL>' & 'web address'

Regards,

Michael

Edit: Yes, you have to upgrade.  It doesn't exist in 8.5.

[#3 · Accepted solution]

Try something like this:

='Click ID - '&OpportunityId&'<url>https://eu1.salesforce.com/'&OpportunityId

[raynac]

Thanks, Michael!  This was extremely helpful.  Since my company was still on an old version of Qlikview there was no Link option under "Representation".

[raynac]

Thank you SO much, Kai!  You are a lifesaver - this worked great!