Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rvijayanth
New Contributor III

How to display multiple hyperlinks in one cell in QlikSense Straight table?

In QlikSense, I have two dimensions in my straight table - ID and LINK . Sometimes I may have more than on URLs per ID like shown below:  (see ID = 2)

ID                 LINK (as URL representation)

1                    www.google.com

2                    www.cnn.com

2                    www.news.com

3                    www.google.com

I want to be able to show multiple URLs in one column in my straight table as show below:

ID          LINK  (as URL representation)

1             www.google.com

2             www.cnn.com www.google.com

3             www.google.com


I want users to click on one of the two hyperlinks for ID = 2.

Tags (1)
8 Replies
YoussefBelloum
Esteemed Contributor

Re: How to display multiple hyperlinks in one cell in QlikSense Straight table?

Hi,

try this:

=aggr(concat([LINK (as URL representation)]),ID)

rvijayanth
New Contributor III

Re: How to display multiple hyperlinks in one cell in QlikSense Straight table?

Thanks for the reply:- Both values show up correctly but it is not showing up as two links. They show up as one giant  link like www.cnn.com www.google.com


I want to be able to allow users click one of the two links in that one cell. Am I making sense?

devarasu07
Honored Contributor II

Re: How to display multiple hyperlinks in one cell in QlikSense Straight table?

Hi,

Try like this?

=aggr(concat(LINK,'  ' ),ID)

Capture.JPG

rvijayanth
New Contributor III

Re: How to display multiple hyperlinks in one cell in QlikSense Straight table?

Thanks for your reply. The display part is perfect. Unfortunately, we cannot click on www.cnn.com or www.news.com.

They both become one link and try to open the address "http://www.cnn.com%20%20www.news.com/"

YoussefBelloum
Esteemed Contributor

Re: How to display multiple hyperlinks in one cell in QlikSense Straight table?

Unfortunately you cant do that..

devarasu07
Honored Contributor II

Re: How to display multiple hyperlinks in one cell in QlikSense Straight table?

Hi,

expected way can't be done.

luismadriz
Valued Contributor

Re: How to display multiple hyperlinks in one cell in QlikSense Straight table?

Hi,

As it seems not possible, maybe you'd like to do it using multiple columns? but you may need to define a limit though

Something like this:

Links:

Load *,

     'Link' & Autonumber(recno(), ID) as URLs;

Load * inline [

ID,LINK

1,www.google.com

2,www.cnn.com

2,www.news.com

3,www.google.com];

Untitled.png

At least each link is Qlikable...

You may not really need Link1, Link2, etc, as you could find those values using FirstSortedValue but I like using the load script as is makes it easier to maintain later on,

I hope this helps

Cheers,

Luis

rvijayanth
New Contributor III

Re: How to display multiple hyperlinks in one cell in QlikSense Straight table?

Thanks for the reply. I will try this and let you know.