Linking Table value to a sheet in QlikSense

[#1]

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

[#2]

Hi All,

Please help me in this.

Thanks,

Ruchika

[alishankhaliqe]

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]

Hi,

Have you tried below extension?

GitHub - stefanwalther/sense-navigation: Sheet Navigation + Actions for Qlik Sense.

[#5]

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]

There is extension which might help you in your requirement.

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

[#7]

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

[#8]

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]

There instead of External Url use URL for required sheet

[alishankhaliqe]

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 tables are properly connected, with no island tables

thanks

Ali Shan Khaliq