Hi Community,
I have a requirement to show hierarchy for that i have created view using SQL .
Can anyone help to reproduce the equivalent QlikView script.
Thanks in Advance.
SQL Query:
Select
LEAF.TREE_NODE_NUM,
RANGE_FROM as ALTACCT,NODE_NAME, NODE_NUM,TREE_LEVEL_NUM
from
( SELECT TREE_NODE_NUM, RANGE_FROM
FROM PSTREELEAF
WHERE SETID = 'SHITA'
AND TREE_NAME = 'SHITA_BILANCIO'
) LEAF
inner join
(
SELECT X.Tree_Node_NUM ,X.TREE_LEVEL_NUM,
ltrim(Sys_connect_by_path(X.Tree_Node,'/'),'/') NODE_NAME ,
ltrim(Sys_connect_by_path(X.Tree_Node_Num,'/'),'/') NODE_NUM
from
(
Select * from PSTREENODE
WHERE SETID = 'SHITA' AND TREE_NAME = 'SHITA_BILANCIO'
) X
connect by prior X.Tree_Node_NUM =X.Parent_Node_Num
) SPLITData
on LEAF.TREE_NODE_NUM = SPLITData.Tree_Node_NUM
where NODE_NAME like 'ALL%'
Regards,
Venkat.