Need help to Convert SQL query to QlikView script

[Anonymous]

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.