Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a basic Employee table with Empid,Ename,Mgrid with following values
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??
Searach Hierarchy from Reference manual and use the same here..
To get this information I did the LOAD below:
(ooxml, embedded labels, table is Sheet1);
LOAD Empid as Mgrid,
Ename as Mname
This way I've created a new field with the Name of the manager of the Employee.
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?