URL Link in Table

[cfountain72]

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

[camflawless · Accepted solution]

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. 

[Levi_Turner · Accepted solution]

Hey @cfountain72

So add things as a dimension and use similar formatting:

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

[cfountain72]

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!

[benwashburne]

@Levi_Turner  

I have a follow on to this topic, perhaps you could help? I am wondering how to make the field in my table that I have chosen to be the URL searchable by another ID.  For example, my URL references a location using a system ID that users are not familiar with. They are familiar with a different ID. However, if I make the familiar ID the URL Label, it is only beneficial in that they can view that ID but that can not SEARCH within that field to find that ID. I would have to put a column next to my URL column that just displays the familiar ID. Is there anyway to incorporate both into the URL field/column?

Thanks!

Ben

[Levi_Turner]

Not directly. So you mentioned a method by throwing the dimension into the table. Another would be to have a filter object near the viz so users can filter there.

[benwashburne]

Understood. Thank you!

[maykerreyes]

In case somebody tries to do it within Qlik: ='https://qliksenseservername/sense/app/777d910b4-7fca-48d8-8b27-9ecaf1da72b2/sheet/e0b88fb2-cf24-45be-bd13-2b55a488e47f/state/analysis/select/OwnerName /'&OwnerName

OwnerName is the dimension name. Qlik will pass as a parameter the Ownername selected.