Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

ychaitanya
Contributor 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??

Tags (1)
3 Replies

Re: Need Help.!

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

gabriel_kirst
Contributor III

Re: Need Help.!

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
Contributor III

Re: Need Help.!

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?

Community Browser