Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
cfountain72
Creator
Creator

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 (5)
2 Solutions

Accepted Solutions
camflawless
Contributor
Contributor

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. 

View solution in original post

Levi_Turner
Employee
Employee

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

View solution in original post

7 Replies
camflawless
Contributor
Contributor

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
Employee
Employee

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
Creator
Creator
Author

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
Partner - Creator
Partner - Creator

@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
Employee
Employee

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
Partner - Creator
Partner - Creator

Understood. Thank you!

maykerreyes
Contributor II
Contributor II

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.