Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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