topic Re: Hyperlink to be added in pivot table in QlikView

Hyperlink to be added in pivot table

santhosh_k_n — Wed, 16 Apr 2014 10:03:22 GMT

Hi all,

I need to add hyperlink(open tab) on the values of the one of the column in a pivot table.

Please guide.

Re: Hyperlink to be added in pivot table

Thu, 17 Apr 2014 02:23:14 GMT

Hi Santhosh,

You need to use Field Event Triggers to achieve this, it's under Document Properties -> Triggers.

Attached is the sample qvw

Thanks,

Jyotsna

Re: Hyperlink to be added in pivot table

fkeuroglian — Thu, 17 Apr 2014 03:05:36 GMT

see the example attached

good luck!

Fernando

Re: Hyperlink to be added in pivot table

santhosh_k_n — Thu, 17 Apr 2014 10:07:38 GMT

Hi,

This is help full, But if I use the same field in another sheet the tab change is effecting.

I want this to be applied on one sheet and if i use the same field in another sheet should be normal.

Re: Re: Hyperlink to be added in pivot table

Thu, 17 Apr 2014 11:02:55 GMT

Hi Santhosh,

You need to just add "Clear Field" action to achieve this

PFA.

Re: Hyperlink to be added in pivot table

clondono — Fri, 29 Apr 2016 22:26:55 GMT

Thank you Fernando. I used your method in a issue I was having with a link. By any chance, do you know how to remove the underline from the hyperlink text in the field?