topic Hyperlink In Pivot table in QlikView

Hyperlink In Pivot table

Fri, 03 Apr 2015 08:03:02 GMT

I have a table data like:

For a particular Req Id and Legal Name , I can have one or more than one Matched Id and Matched Name (Matched Name is partially or fully matching name.). there are two requirement.

Req Id	Legal Name	Matched Id	Matched Name
101	Test1	1021	Testcorp
101	Test1	1022	Testin
101	Test1	1023	Testing
102	Test2	1056	User
103	NewName	1078	NewName Find
103	NewName	1079	NewName Exist
103	NewName	1065	Get NewName
103	NewName	1034	No NewName

1) I need to put Hyperlink on Req Id (to open some external link.).

2) Along with this I also need to do merging kind of thing on Req ID & Legal name to avoid duplicacy. I acheived this from Pivot table but now I am not able to create hyperlink on dimension column.

The final table should be like alongwith Hyperlink on Req Id column.

Req Id	Legal Name	Matched Id	Matched Name
101	Test1	1021	Testcorp
		1022	Testin
		1023	Testing
102	Test2	1056	User
103	NewName	1078	NewName Find
		1079	NewName Exist
		1065	Get NewName
		1034	No NewName

Any suggestion .....

Message was edited by: Vineeta Dahiya

Re: Hyperlink In Pivot table

Gysbert_Wassenaar — Sat, 04 Apr 2015 08:30:48 GMT

Dimensions in pivot tables cannot be made hyperlinks. But it is possible to assign an Open URL action to the OnSelect field trigger of the Req Id field. You can do that on the Triggers tab of the document properties window.

Re: Hyperlink In Pivot table

Mon, 06 Apr 2015 10:50:02 GMT

I tried the same feature but somehow the trigger is not opening.

I select the field and assign the action to Open URL like www.google.com , but it is not opening the URL.

Correct me if I am doing something wrong. Is there any other setting to Open a external URL. Please suggest

Re: Hyperlink In Pivot table

Tue, 07 Apr 2015 05:29:07 GMT

Please help. It is urgently needed for one of the client's requirement.

Re: Hyperlink In Pivot table

Anonymous — Tue, 07 Apr 2015 10:22:04 GMT

Add an expression to your pivot table, choose "Link" as representation and add somthing like this

to your expression ='Link'&'<url>https://eu1.salesforce.com/'&OpportunityId

In the case above this will open SalesForce.com and open the opportunity in salesforce.

Re: Hyperlink In Pivot table

Tue, 07 Apr 2015 11:20:30 GMT

But I need the dimesion to be merged and hyperlinked also. If I put it as expression, the column value will be repetative.

Re: Hyperlink In Pivot table

Anonymous — Tue, 07 Apr 2015 11:51:11 GMT

Yes, you will have a column containing the link text for each row. It would look something like this.

Apart from this I can't see any other way of embedding link inside a pivot table dimension.

Re: Hyperlink In Pivot table

Wed, 08 Apr 2015 08:48:53 GMT

Thanks Morris. I understand the concept. But the problem is Client want the representation in that manner. If I add this link as a column , this is again repeatative value. Ideally, he want this link applied in 668 , 669 referring the example you shared.

I am looking for OnSelect and OnChange trigger in Field Event Trigger. But this seems not working as well.

Re: Hyperlink In Pivot table

lookforward1 — Thu, 09 May 2019 01:46:49 GMT

Hi Morris,

I am able to get the url in the values section in pivot table but not as a hyperlink.Can you provide steps on how you achieved this per your screenshot?Also i don't see representation in values section.

Thanks!