Discussion Board for collaboration related to Creating Analytics for QlikView.
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:
OptionID as ParentOptionID,
SQL SELECT *
Load OptionID as HiaerOp, OptionID as HiearParent, DimSalesPhases.OptionID as HiearParent,DimSalesPhases.Milestone as HiearMilestone,DimSalesPhases.Phase as HiearPhase
My OptionID is my ID for OptionText - How ever i have substringed my OptionText into to- Milestone and Phase
Go to Solution.
go to this link
hope it helps
Thank you! I tried that link but could not get it to work.
But the document you posted helped me alot:
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;
NODE_ID as NODE_ID_H,
PARENT_NODE_ID as PARENT_NODE_ID_H,
VALUE as ID,
VALUE as NAME
This is what i finished with and then it worked - Thanks alot!