Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please any help in creating hierarchy levels in qlikview will be appreciated:
Below is code in oracle, where LEVEL field is created, which I want to implement in qlikview:
SELECT employee_id, last_name, manager_id, LEVEL
FROM employees
START WITH manager_id in ('100')
CONNECT BY PRIOR employee_id = manager_id;
EMPLOYEE_ID LAST_NAME MANAGER_ID LEVEL
----------- ------------------------- ---------- ----------
101 Jane 100 1
108 Greenberg 101 2
109 Faviet 108 3
110 Chen 108 3
111 Sciarra 108 3
112 Urman 108 3
113 Popp 108 3
Thanks in advance:)
Regards
Neetha
Then it's a problem with your SQL or connection. It's not a QLikView issue.
I am getting this error when I use sqlquery and hierarchy prefix together.
Dear Neetha,
The Hierarchy function is a QlikView Function and not a sql function.
You can not use it with your sql query.
You will have to fetch below data using select query and then you can use the hierarchy function.
Select EmpID,ManagerId, EmpName From XYZ;
Regards,
Kaushik Solanki
It should work, according to Help:
The hierarchy prefix is used to transform a hierarchy table to a table that is useful in a QlikView data model.
It can be put in front of a Load or a Select statement and will use the result of the loading statement as input for a table transformation.
Thanks Lucian..
Hi Lucian/Kaushik,
Thanks for both solutions, which are working.
Regards
Neetha
Hi luciancotea,
Thanks for your solutions.This is Very helpful to me.