Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
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 ???
 OmarBenSalem
		
			OmarBenSalem
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		What's the point? If you click on uk10000233456 for example, where do you want it to send you?
 
					
				
		
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
		
			OmarBenSalem
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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:
The field will be clickable and will send you to facebook in this example above
 
					
				
		
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
		
			OmarBenSalem
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Is this good?
 OmarBenSalem
		
			OmarBenSalem
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
 
					
				
		
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
		
			OmarBenSalem
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		You do it in the straight table in Qlik Sense:
 OmarBenSalem
		
			OmarBenSalem
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Victor,
If this worked for you, please mark the answer as right so the rest of the communitiy would be notified.
Omar,
