Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

raynac
New Contributor III

Make Column Data into Clickable HTML Link?

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

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Make Column Data into Clickable HTML Link?

Try something like this:

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

2013-12-18_17h53_42.png

4 Replies
mov
Esteemed Contributor III

Re: Make Column Data into Clickable HTML Link?

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.

Not applicable

Re: Make Column Data into Clickable HTML Link?

Try something like this:

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

2013-12-18_17h53_42.png

raynac
New Contributor III

Re: Make Column Data into Clickable HTML Link?

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
New Contributor III

Re: Make Column Data into Clickable HTML Link?

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

Community Browser