Need help to Convert SQL query to QlikView script

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

topic Need help to Convert SQL query to QlikView script in QlikView