Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ychaitanya
Creator III
Creator III

Need Help.!

HI

I have a basic Employee table with Empid,Ename,Mgrid with following values

Empid,Ename,Mgrid
1,A,

2,B,1

3,C,2

4,D,2

Now i am displaying the List bos Empid ,Ename and Mgrid....So if user selects Empid .. we will get Ename and Mgrid values correspondingly.

But if i now want to show the manager name for that employee (which can drawn from the mgrid for that corresponding Empid which is again a empid).. Can you please help me in achieveing this??

3 Replies
MK_QSL
MVP
MVP

Searach Hierarchy from Reference manual and use the same here..

Anonymous
Not applicable

Hi!

To get this information I did the LOAD below:

LOAD Empid,

     Ename,

     Mgrid

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

LEFT JOIN

LOAD Empid as Mgrid,

     Ename as Mname

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

This way I've created a new field with the Name of the manager of the Employee.

Regards,

Gabriel

ychaitanya
Creator III
Creator III
Author

I accept with the possibility of Hierarchial Load,Lookup and Excel Files..But is there any way that we could do in Dashboard using any functions?