Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Linking Table value to a sheet in QlikSense

Hi All,

I am trying to Implement a link between a sheet and value in table.

Mainly, when we click on the on one value in a table, we get a new sheet showing further details of that topic.

Please help asap

Thanks

12 Replies
Not applicable

Re: Linking Table value to a sheet in QlikSense

Hi All,

Please help me in this.

Thanks,

Ruchika

alishan99
New Contributor

Re: Linking Table value to a sheet in QlikSense

Hi Rhichika

when loading multiple tables, the links between the tables are defined by the field
names. At the end of the script run, the existing tables will be evaluated. If the same field name is found in more than one table, this field will be considered to be a field that links both the tables. This way, a data model is created. The logic in the script evaluation is hence identical in Qlik Sense and QlikView


Load CustomerNo as CustomerID, … From Table1 … ;
Load CustomerID, … From Table2 … ;


Also, it is important that you make sure that you don’t have any unwanted links. For
example, you may have a field called Description in two different tables. This is of
course not a key,


Load Description as Description1, … From Table1 … ;
Load Description as Description2, … From Table2 … ;


Try This


Thanks


Ali Shan Khaliq

devarasu07
Honored Contributor II

Re: Linking Table value to a sheet in QlikSense

Not applicable

Re: Linking Table value to a sheet in QlikSense

Hi Ali,

I am not trying to links columns in the data; perhaps there is some confusion.

I want to link the sheets of Qliksense dashboard.

For example, if I click on the one key value like Emp ID in a table, I can further drill down on his details; which are present in another sheet/view.

Thanks,

Ruchika

shraddha_g
Honored Contributor III

Re: Linking Table value to a sheet in QlikSense

There is extension which might help you in your requirement.

TRY http://branch.qlik.com/#!/project/58c6f48f2655dcb3ae7992c1

Highlighted
Not applicable

Re: Linking Table value to a sheet in QlikSense

Hi Shraddha,

Thanks for reply.

But I don't want to link to external URL. I want to link to another sheet in the same App. Something similar to the Qlik sense KPI feature but in the charts and the table

Ruchika

Not applicable

Re: Linking Table value to a sheet in QlikSense

Hi,

I don't need an external object for the linking as we can use KPI also for the same function. But I need to implement the similar feature in chart and the table.

Thanks,

Ruchika

shraddha_g
Honored Contributor III

Re: Linking Table value to a sheet in QlikSense

There instead of External Url use URL for required sheet

alishan99
New Contributor

Re: Linking Table value to a sheet in QlikSense

linking tables based on the identical
field names, let’s examine the actual field names in the new tables, compared to the original database.
The original fields were [Salesperson ID], [Salesperson Name], [Regional
Director], and [VP Sales]. In comparison, the users who provided the
spreadsheet used slightly different field names:
Salesperson should be called [Salesperson Name]
RD should be called [Regional Director]
Director should be called [Regional Director]
In order to repair the broken links, you need to rename the fields accordingly in
the load script, using the same renaming technique presented earlier with the
keyword AS:
//==================================================
// Load Directors From the Overriding Table:
//==================================================
Directors:
LOAD
Salesperson as [Salesperson Name],
RD as [Regional Director]
FROM
[..\Data\Text Files\Sales Hierarchy Override.xlsx]
(ooxml, embedded labels, table is Director)
;/
/==================================================
// Load VPs From the Overriding Table:
//==================================================
VPs:
LOAD
Director as [Regional Director],
[VP Sales]
FROM
[..\Data\Text Files\Sales Hierarchy Override.xlsx]
(ooxml, embedded labels, table is VP)
; After running the corrected script, the data model will look normal again. All the link.PNGtables are properly connected, with no island tables



thanks


Ali Shan Khaliq