How to create hierarchy levels in qlikview

[Anonymous]

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

[luciancotea]

Then it's a problem with your SQL or connection. It's not a QLikView issue.

[Anonymous]

I am getting this error when I use sqlquery and hierarchy prefix together.

[kaushiknsolanki]

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

[luciancotea]

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.

[kaushiknsolanki]

Thanks Lucian..

[Anonymous]

Hi Lucian/Kaushik,

Thanks for both solutions, which are working.

Regards

Neetha

[dineshraj]

Hi luciancotea,

Thanks for your solutions.This is Very helpful to me.