Qliksense hyperlink

[Evanpap]

Hi all,

I want some help to the below problem I have with a hyperlink:

I have a table with unique ID numbers (column name vault_doc_id) like 415076, 415077.

These numbers are documents in a specific software we use internally.

The function I use is the following:  ='https://website.com/ui/#doc_info/' & vault_doc_id so ideally for the example number vault_doc_id= 415076 it would redirect me to the following address by clicking on it: =https://website.com/ui/#doc_info/415076

However for some reason it doesn't work and the link I see whatever number I click is the following =https://website.com/ui/#doc_info/1

Do you may have any idea why I have this error? How can this be corrected?

Thanks in advance for the help,

Evan

[Dalton_Ruer · Accepted solution]

Not sure what is going wrong in your expression. I created a simple table with  a Key and a Value and then said to show my key as a Link, then added the 'Link URL' value as ='https://website.com/ui/#doc_info/'&Value

When I hover over the Key field it displays appropriately as expected. 

If you want to try from my example code here it is:

MyTable:
Load * Inline [
Key, Value
A, 1
B, 2
C, 3
D, 4
E, 938493
];

[Evanpap]

Hello Ruer,

Thanks for your reply.

This is exactly I did but it didn't help. So it seems that there are no other alternatives..

Should the value be in a specific format? 

Thanks,

Evan

[Bill_Britt]

Hi,

What do you get (URL) when you click on it? What are you expecting?

Bill

[Evanpap]

Hi Bill,

I expect the below:

https://website.com/ui/#doc_info/415076

where 415076 is the dynamic value and the expression is this: 'https://website.com/ui/#doc_info/' & vault_doc_id 

As soon as I use the vault_doc_id (it is a measure and is refreshing in the qliksense report via ODBC connection) in the label then I get this: https://website.com/ui/#doc_info/1

The workaround is not to label the hyperlink and the user to see literally:  https://website.com/ui/#doc_info/415076

What I ideally want is to see is only the vault_doc_id (e.g. 415076) and I use it in the label section

I saw that if my source is an excel file then I do not have this problem.

Thanks,

Evan