Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
cfountain72
New Contributor III

URL Link in Table

Hi,

I'm trying to add a URL link to table. I have this in the Field expression:

'https://helpdesk.tgh.org/#/home/ticketsearch/editticket/' & TicketID

When I do this, the link does work, but the entire link also appears in the cell. How do I make it so that just the TicketID appears in the cell, but the hyperlink still works?

Thanks in advance,

Chris

Labels (6)
2 Solutions

Accepted Solutions
camflawless
New Contributor

Re: URL Link in Table

You will need to enable URL representation and edit the URL label value..

Click the dropdown of the field expression and ensure "URL" is selected from the Representation dropdown. Then, in the URL label expression editor, you would enter " =TicketID". 

This will preserve the hyperlink within the cell, but it will be labeled and displayed using only  the TicketID value. 

Employee
Employee

Re: URL Link in Table

Hey @cfountain72

So add things as a dimension and use similar formatting:

2019-01-03 16_34_45-URL Example - My new sheet _ Sheets - Qlik Sense.png

For the expression of the dimension I have: ='https://helpdesk.tgh.org/#/home/ticketsearch/editticket/' & ID

3 Replies
camflawless
New Contributor

Re: URL Link in Table

You will need to enable URL representation and edit the URL label value..

Click the dropdown of the field expression and ensure "URL" is selected from the Representation dropdown. Then, in the URL label expression editor, you would enter " =TicketID". 

This will preserve the hyperlink within the cell, but it will be labeled and displayed using only  the TicketID value. 

Employee
Employee

Re: URL Link in Table

Hey @cfountain72

So add things as a dimension and use similar formatting:

2019-01-03 16_34_45-URL Example - My new sheet _ Sheets - Qlik Sense.png

For the expression of the dimension I have: ='https://helpdesk.tgh.org/#/home/ticketsearch/editticket/' & ID

cfountain72
New Contributor III

Re: URL Link in Table

Thanks! I tried similar text, but never that exact syntax. I would've guessed that that expression would just show the word TicketID over and over again.
Thanks again!