topic Re: Multiple Hyperlinks as comma separated values in straight table in QlikView

Multiple Hyperlinks as comma separated values in straight table

avinashelite — Fri, 30 Oct 2015 07:22:43 GMT

Hi Friends,

I have requirement to show Multiple Hyperlinks as comma separated values in straight table so that end user will have the option to select which ever link he needs.

Temp:

Load * Inline

[

AA,BB

1,2

1,4

3,5

];

LOAD AA,

Concat(BB,',')as T

Resident

Temp

Group by

AA;

here i get the output like

AA T

1 2,4

3 5

Now if I create hyperlink for T column it will treat 2,4 as a single value and but I need this to values as separate link to navigate

Hope you got my requirement

Re: Multiple Hyperlinks as comma separated values in straight table

jagan — Fri, 30 Oct 2015 07:27:56 GMT

Hi Avinash,

It is not possible like this, instead you can display those 2 and 4 in two columns and assigns link to it. In Table there is no way to assign multiple links for single cell.

Hope this helps you.

Regards,

Jagan.

Re: Multiple Hyperlinks as comma separated values in straight table

avinashelite — Fri, 30 Oct 2015 08:00:31 GMT

Hi Jagan,

Thanks a lot for the reply, Yes I knew this option but is their any work around except this ?

Re: Multiple Hyperlinks as comma separated values in straight table

petter — Fri, 30 Oct 2015 08:05:00 GMT

I think the only option would be to develop an Object Extension to achieve it.

Re: Multiple Hyperlinks as comma separated values in straight table

jagan — Fri, 30 Oct 2015 08:08:36 GMT

You can write your own extension and use it, and the disadvantage of this is it won't work in IE plugin and you have to create it using HTML, CSS, Javascript etc.

Other than this there is no way of achieving this.

Regards,

Jagan.

Re: Multiple Hyperlinks as comma separated values in straight table

marcus_sommer — Fri, 30 Oct 2015 09:18:45 GMT

Maybe this is helpful: QlikTip #39: Displaying Html content within QlikView (Minimalistic HtmlTextBox Object Extension).

- Marcus