Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
smithc2005
New Contributor II

Using output from straight table in another straight table

I have a data model that is working as intended for a straight table but I am running into an issue using the output of one table as input on another. Each Employee has an ID. I'm able to successfully pull a list of employees, but I need to pull their supervisors and their supervisor's supervisor. I thought I'd have to do it in 3 separate tables. Table 1 is fine, but for Table 2, and later Table 3, I am unable to figure out how to use a pulled field as a var to pull a record. 

Ideally, I'd like to pull the other Employee_Name's using the Supervisor ID from another.

Table1

Employee_NameEMP_IPSupervisor_ID
Bob12
Susan34

 

Table2

Supervisor_ID
2
4
Labels (1)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Using output from straight table in another straight table

It is not possible to use the "output" of one or any table as an input to any other table. However since the tables use the underlying data model and the selections being made in the fields you could achieve the same effect but you will need to use expressions/measures to "recreate" the output built on the same fields. It is not possible to directly link tables with each other.

View solution in original post

1 Reply
Highlighted
MVP
MVP

Re: Using output from straight table in another straight table

It is not possible to use the "output" of one or any table as an input to any other table. However since the tables use the underlying data model and the selections being made in the fields you could achieve the same effect but you will need to use expressions/measures to "recreate" the output built on the same fields. It is not possible to directly link tables with each other.

View solution in original post