Discussion board where members can get started with QlikView.
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.
RANGE_FROM as ALTACCT,NODE_NAME, NODE_NUM,TREE_LEVEL_NUM
( SELECT TREE_NODE_NUM, RANGE_FROM
WHERE SETID = 'SHITA'
AND TREE_NAME = 'SHITA_BILANCIO'
SELECT X.Tree_Node_NUM ,X.TREE_LEVEL_NUM,
ltrim(Sys_connect_by_path(X.Tree_Node,'/'),'/') NODE_NAME ,
Select * from PSTREENODE
WHERE SETID = 'SHITA' AND TREE_NAME = 'SHITA_BILANCIO'
connect by prior X.Tree_Node_NUM =X.Parent_Node_Num
on LEAF.TREE_NODE_NUM = SPLITData.Tree_Node_NUM
where NODE_NAME like 'ALL%'