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

[rvijayanth]

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.

[YoussefBelloum]

Hi,

try this:

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

[rvijayanth]

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]

Hi,

Try like this?

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

[rvijayanth]

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]

Unfortunately you cant do that..

[devarasu07]

Hi,

expected way can't be done.

[luismadriz]

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];

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]

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