topic Re: Need Help.! in QlikView

Need Help.!

ychaitanya — Wed, 15 Oct 2014 14:11:01 GMT

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

Re: Need Help.!

MK_QSL — Wed, 15 Oct 2014 14:16:57 GMT

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

Re: Need Help.!

Anonymous — Wed, 15 Oct 2014 14:19:23 GMT

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

Re: Need Help.!

ychaitanya — Wed, 15 Oct 2014 14:23:52 GMT

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?