topic Re: Multiple URL hyperlinks in 1 field in QlikView

Multiple URL hyperlinks in 1 field

awqvuserneo — Wed, 25 Jun 2014 17:21:25 GMT

Hi Folks,

Just wondering if you have encountered a way to put multiple hyperlink URLs into a single field?

When I use this format: within the expression (and change the "Representation" option to URL), it works fine if it only has 1 value:

SiteName<URL>http://www.mysite.com

if I use "Concat" function to put them into "AllURL" field, it appears like this, and it seems the link only work for the last value (in this case -msn).

I appreciate any input/direction.

Cheers,

Anton

Re: Multiple URL hyperlinks in 1 field

vgutkovsky — Wed, 25 Jun 2014 18:31:33 GMT

You're trying to open several tabs in a browser at once?

Re: Multiple URL hyperlinks in 1 field

Anonymous — Fri, 27 Jun 2014 23:08:38 GMT

Hi Vlad,

Not really, what I'm thinking is to allow a user to pick any attachment to open created on the same day. Instead of having to create 1 field per attachment, I prefer to concat all the attachments into a single field. (Note: Though, this is not hard requirement, just a preference.)

For example, if I have 3 attachment files created on the same date, I would like to have a chart with the date as dimension, and 1 field containing the list of "clickable" links (instead of having to copy and paste the actual folder).

I try to avoid having created 3 fields to represent 1 attachment per field because there's no restriction from the actual app on how many attachments can be created for a single date.

If the above may not be easily achieved, would you mind sharing how to build what you've suggested, which having the user to click once, and open multiple tabs ? I appreciate it.

Best regards,

Anton

Re: Multiple URL hyperlinks in 1 field

vgutkovsky — Sat, 28 Jun 2014 00:38:22 GMT

How about just doing it as a pivot table? In your example about, Msft would have 2 sub-rows.

Vlad

Re: Multiple URL hyperlinks in 1 field

Anonymous — Sat, 28 Jun 2014 01:16:21 GMT

Hi Vlad,

Thanks for the idea. I forgot to mention , if I got this working, I will need to associate it with an existing straight chart.

So, yes, it will work using the Pivot if I only have 1 Date Dimension & the hyperlink fields; but unfortunately, it won't work if I were to incorporate this into the other chart.

The alternative I can think of is just to concatenate the location of all the attachment using comma separated (so no hyperlink embedded), and user just need to copy/paste them.

Best regards,

Anton

Re: Multiple URL hyperlinks in 1 field

vgutkovsky — Sat, 28 Jun 2014 05:03:21 GMT

Yeah, or rely on some sort of outside solution that can present a single web address for multiple files (like Sharepoint, I believe)...sorry, don't have any other ideas, unfortunately.

Vlad

Re: Multiple URL hyperlinks in 1 field

awqvuserneo — Sat, 28 Jun 2014 20:02:35 GMT

No worries, I appreciate your suggestion. I'll try to propose your idea of having a separate pivot chart for the attachments, in addition to the existing straight chart they're currently have. Thanks again,

Have a great weekend!

Anton