topic Re: Hyperlink in Straight table ID's in QlikView

Hyperlink in Straight table ID's

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

Hi All,

We have One straight table(Details) and Multiple Text Boxes(Employee and Score) in Qlikview.

Straight Table Name: Details

Text Box1 Name: Employee

Text Box2 Name: Score

When we click Employee Text box, it will show below data in Straight(Details) Table.

Details:

Emp Name	Emp ID	Dept	Dept ID	Location
AAA	E101	XXX	D201	SSS
AAA	E101	XXX	D202	HHH
BBB	E102	YYY	D203	NNN
CCC	E103	ZZZ	D204	MMM

Currently we don’t have Hyperlinks for Emp ID and Dept ID.

How can we apply below Hyperlinks for EMP ID and Dept ID.

For Example, when we click E101, it will redirect to www.google.com_E101 page and like for other ID’s also.

Examples:

E101: www.google.com_E101

E102: www.google.com_E102

E103: www.google.com_E103

D201: www.google.com_D201

D202: www.google.com_D202

D203: www.google.com_D203

D204: www.google.com_D204

When we click Score Text box, it will show below data in Straight(Details) Table.

Name	Score ID	Dept ID	Location
AAA	S301	D205	LLL
AAA	S302	D206	KKK
BBB	S303	D207	VVV
CCC	S304	D208	XXX

Currently we don’t have Hyperlinks for Score ID and Dept ID. How can we apply below Hyperlinks for Score ID and Dept ID.

For Example, when we click S301, it will redirect to www.google.com_S301 page and like for other ID’s also.

Examples:

S301: www.google.com_S301

S302: www.google.com_S302

S303: www.google.com_S303

S304: www.google.com_S304

D205: www.google.com_D205

D206: www.google.com_D206

D207: www.google.com_D207

D208: www.google.com_D208

Re: Hyperlink in Straight table ID's

rameshwarkatkar — Sun, 05 Aug 2018 04:57:16 GMT

hi,

Take button add action Open URL

Wright exp =www.google.com_'&GetFieldSelections(S301)

when you select field and clik on button it will redirect you to that particular Page

Re: Hyperlink in Straight table ID's

BalaBhaskar_Qlik — Sun, 05 Aug 2018 07:07:50 GMT

May be like this:

Details - Straight table

Dimensions: Emp Name,Dept,Dept Id, Location

Calculated Dimension: 'www.google.com_' & [Emp ID] - Label - Emp ID

Expressions: Create some expressions

Score - Straight table

Dimensions: Name,Dept ID, Location

Calculated Dimension: 'www.google.com_' & [Score ID] - Label - Score ID

Expressions: Create some expressions

Re: Hyperlink in Straight table ID's

pooja_prabhu_n — Mon, 06 Aug 2018 09:50:34 GMT

Hi,

In the expression use

=[Emp ID]&'<url>'&'https://www.google.com/'&[Emp ID]

=[Dept ID]&'<url>'&'https://www.google.com/'&[Dept ID]

change the representation to link.

Please fin the attached qvw file