How do embed a URL on a text value?

[jblomqvist]

Hi all,

Is there a way to turn a text value into a clickable URL?

For example

Text is Google and I want to embed a URL onto the text so when people click on Google text it goes to google.com

Is there a way to do this?

[flipside]

In Qlik Sense, add a new Text & Image object, click the plus sign to add text and type 'Google'. Highlight the entered text and click the link icon (second from right) to enter a url.

This is version 3.1 SR4, not sure when it was introduced.

flipside

[jblomqvist]

Hi Shiva and Dave,

Thank you, two things further:

1) I am looking to find a way to do this in Qlik Sense

2) It is a table value. e.g.

OrderID	Text
34343	Jarvis
565623	Clarks
245455	Krypton

The text value contains search query for the URL. E.g. It might be something like google.com/q=Jarvis.

I dynamically replace the q= bit with the Text value from the field above. This generates a unique URL per row above. It was simple as concatenating string and Text field value.

What I want to do is instead of creating a third column for the URL, I want to embed the URL in the Text field if possible over the Text value.

Sorry I should have explained further.

Not sure if this bit is possible.

[flipside]

You can add an extra field to a table and change its 'Representation' from text to URL but I think it only displays a common word such as 'Link' or whatever you choose.

There might be some extensions that do what you need.

[jblomqvist]

Hi Dave,

Yes I am doing that currently.

The problem is it shows the full URL.

It's nicer if there was a way to embed the link into the text itself so the users don't have to deal with an extra column and makes presentation nicer.

[flipside]

If you type a word (eg Link) in the URL label it hides the actual URL, but I agree it would be better to have this in the data field.

Have you looked at Qlik Branch to see if there's an extension that does what you want?

[Patrik_Lundblad · Accepted solution]

Hi John,

Qlik Sense 3.2 allows you to put one field as text and one fields as the URL. Before that we only allowed static text.

In the field you use the URL field, and in the URL label you use the field you want to show.

Cheers,

Patrik.

[jblomqvist]

Hi Patrik,

Thank you for the clarification.

I have version 3.1 right now but will change the functionality when we upgrade to 3.2