topic Re: Adding Hyperlinks to Table Box? in QlikView

Adding Hyperlinks to Table Box?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello, I have imported a set of data that includes hyperlinks. Is it possible to have those hyperlinks show in my Table Box?

Re: Adding Hyperlinks to Table Box?

vishsaggi — Sat, 20 Jan 2018 00:22:30 GMT

Not in a tablebox, but you can do that in Straight table using '<URL>'.

Re: Adding Hyperlinks to Table Box?

devarasu07 — Sat, 20 Jan 2018 02:17:44 GMT

Hi,

AFAIK, qlikview table box object don't have such a feature. as Naga suggestion should work (Table box. straight table, pivot and text box object etc)

Thanks

Deva

Re: Adding Hyperlinks to Table Box?

Anonymous — Sat, 20 Jan 2018 07:51:11 GMT

hi,

i think you can try it on text box or button actions ,

to show links in your dashboard.

Thanq

Re: Adding Hyperlinks to Table Box?

Anonymous — Tue, 23 Jan 2018 14:21:49 GMT

I have created so it displays as a pivot. How would I get the links to display? Would I have to go in and edit the code?

Re: Adding Hyperlinks to Table Box?

Peter_Cammaert — Tue, 23 Jan 2018 14:36:04 GMT

See Pivot Table Object->Properties->Expressions->Display Options->Representation. Select Link from the list.

IIRC, you can separate a link text from a link url by inserting a tag '<URL>' between the two. For an example, see show Url as a link in QlikView | Qlik Community

And yes indeed, works only for expressions.

Re: Adding Hyperlinks to Table Box?

Anonymous — Tue, 23 Jan 2018 20:13:07 GMT

EDIT: So I got them to show as the Expressions, but when I change the Representation to links nothing really changes.

To provide clarity the original excel doc that QV is using has these fields as hyperlinks, which is what I would like to keep. So I want it to say "Owner" for example and if they click that it links to an InfoPath form.

That is how the original file works.

Re: Adding Hyperlinks to Table Box?

Peter_Cammaert — Wed, 24 Jan 2018 13:16:43 GMT

It works for me.

Did you follow Alessandro Saccone's instructions in the link I provided?

More info can be easily found in the Qlik On-line help which is pretty good. In Straight Table ‒ QlikView, scroll down to Chart Properties: Expressions > Display Options -> Representation -> Link.

Re: Adding Hyperlinks to Table Box?

Anonymous — Wed, 24 Jan 2018 13:43:23 GMT

My requirement was a little different than what was in the link but I got it... took longer than it should have for me to get it

=[VALUE1]&<url>'URL'&[VALUE2]&'URL'

Re: Adding Hyperlinks to Table Box?

devarasu07 — Wed, 24 Jan 2018 14:00:26 GMT

refer to the attached sample