Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Need help to Convert SQL query to QlikView script

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.