topic Re: Hiearchy treeview in QlikView

Hiearchy treeview

Wed, 01 May 2013 09:08:31 GMT

Hello, i tried to make an hiearchy in my edit script, by reading some of the examples in here, but i cant seem to get it right.

So i hope someone can help me:

I have this Table:

QUALIFY*;

UNQUALIFY SalesPhasesKey;

DimSalesPhases:

LOAD SalesPhasesKey,

FieldID,

OptionText,

OptionID,

OptionID as ParentOptionID,

Milestone,

Phase;

SQL SELECT *

FROM Hej.dbo.DimSalesPhases;

UNQUALIFY*;

Hiearcgy:

Hierarchy(HiaerOp,HiearParent,HiearMilestone,',HiearPhase, TreeView)

Load OptionID as HiaerOp, OptionID as HiearParent, DimSalesPhases.OptionID as HiearParent,DimSalesPhases.Milestone as HiearMilestone,DimSalesPhases.Phase as HiearPhase

Resident DimSalesPhases;

My OptionID is my ID for OptionText - How ever i have substringed my OptionText into to- Milestone and Phase

Re: Hiearchy treeview

er_mohit — Wed, 01 May 2013 09:40:40 GMT

go to this link

http://community.qlik.com/thread/60495

hope it helps

Re: Hiearchy treeview

Wed, 01 May 2013 18:10:47 GMT

Thank you! I tried that link but could not get it to work.

But the document you posted helped me alot:

HierarchyTable:

Load distinct DimSalesPhases.Milestone as VALIE, DimSalesPhases.Milestone & '-Mile' as NODE_ID, DimSalesPhases.Phase & '-Phase' as PARENT_NODE_ID resident DimSalesPhases;

Load distinct DimSalesPhases.Phase as VALUE, DimSalesPhases.Phase & '-Phase' as NODE_ID, DimSalesPhases.Milestone & '-Mile' as PARENT_NODE_ID resident DimSalesPhases;

Hiearchy_Table:

Hierarchy(NODE_ID_H,PARENT_NODE_ID_H,ID,PARENT_NAME,NAME,Treeview) Load

NODE_ID,

NODE_ID as NODE_ID_H,

PARENT_NODE_ID as PARENT_NODE_ID_H,

VALUE as ID,

VALUE as NAME

Resident HierarchyTable;

This is what i finished with and then it worked - Thanks alot!