Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How can i create Hyperlink in Qlik sense

stalwar1@Hi All,

   Who can help me out in creating hyperlink on click sense? what I have seen online isn't sufficient enough

TICKET_ID_

uk10000233456

us10067978799

us67887979979

us97745787834

let's say that's my role, I want to make eack of those roles clickable on a table, how ???

27 Replies
OmarBenSalem
Esteemed Contributor

Re: How can i create Hyperlink in Qlik sense

What's the point? If you click on uk10000233456 for example, where do you want it to send you?

Not applicable

Re: How can i create Hyperlink in Qlik sense

To this link https://vocfeedback.gsk.com/viewfeedback.asp?feedback_id=, with the number immediately after the "=" sign.  Right now, what I am doing is concatenating this link to the TICKT_ID_ in my SQL and then turning it into a link on my table. I know there should be an efficient way to do it

OmarBenSalem
Esteemed Contributor

Re: How can i create Hyperlink in Qlik sense

First of all, please upgrade to Qlik Sense 3.2.1 (the latest version),

Now, If you have a field with URLs, you can use it in a straight table and choose representation as URL:

Capture.PNG

The field will be clickable and will send you to facebook in this example above

Not applicable

Re: How can i create Hyperlink in Qlik sense

tell me the format the link can be put in the expression and how it can be tied to each of those TICKET_ID_??

OmarBenSalem
Esteemed Contributor

Re: How can i create Hyperlink in Qlik sense

Is this good?

Capture.PNG

OmarBenSalem
Esteemed Contributor

Re: How can i create Hyperlink in Qlik sense

1) Upgrade to Qlik Sense 3.2 (or 3.2.1 latest version)

2) choose a straight table

3) as dimension : ='https://vocfeedback.gsk.com/viewfeedback.asp?feedback_id='&upper(TICKET_ID_)

a) Representation: URL

Not applicable

Re: How can i create Hyperlink in Qlik sense

there are millions of rows of the TICKET_ID_, hence I cant add them up to the link manually as u have done.

how do it do this https://vocfeedback.gsk.com/viewfeedback.asp?feedback_id='TICKET_ID_' in the expression, so it automatically attaches each specific TICKET_ID_??

OmarBenSalem
Esteemed Contributor

Re: How can i create Hyperlink in Qlik sense

You do it in the straight table in Qlik Sense:

Capture.PNG

OmarBenSalem
Esteemed Contributor

Re: How can i create Hyperlink in Qlik sense

Victor,

If this worked for you, please mark the answer as right so the rest of the communitiy would be notified.

Omar,

Community Browser