What is the differences between Hierarchy with function and without function.

Mon, 30 Jul 2012 09:43:31 GMT

Hi All

Can someone please confirm whether hierarchy with function(Method:1) works in the same way as hierarchy without function(Method:2)? If both works in the same way then its fine. If not please let me know what are differences between these two methods?

Method:1

Hierarchy(NodeID, ParentID, NodeName) Load
NodeID,
ParentID,
NodeName
From data.xls (biff, embedded labels, table is
[Sheet1$];

Method:2

Load
NodeID,
ParentID,
NodeName,
NodeID&'/'&ParentID&'/'&NodeName AS Tree
From data.xls (biff, embedded labels, table is
[Sheet1$];

Thanks,
Attitude

Re: What is the differences between Hierarchy with function and without function.

jcarpenter9 — Tue, 07 Aug 2012 13:24:43 GMT

Both will probably work if your data includes rows for all of the ParentID values as NodeID. I tried your without-function method on data where NodeID only represented the child values; the list box displayed correctly in tree view, but only the child values were selectable, while the parent values were always greyed out.

Please try both methods with some sample data and post your results here.

~James

topic Re: What is the differences between Hierarchy with function and without function. in QlikView

What is the differences between Hierarchy with function and without function.

Re: What is the differences between Hierarchy with function and without function.