topic Re: Elements having root-parent element with certain attribute in Listbox in QlikView

Elements having root-parent element with certain attribute in Listbox

Thu, 18 Aug 2016 16:44:41 GMT

Hi folks,

I currently struggle with the following:

I have a hierachical structure of elements. Each element has an attribute parentID referring to its parent element and an attribute A with possible values X, Y, Z. Elements where the parentID is null, are root elements.

What I want to do, is having a listbox in tree view (so far so good), which contains all root elements having A = X and all its children regardless of their attribute A's value (as sub elements in the tree view).

Tried a couple of different set analyses but couldn't achieve the desired result...

Any help pointing me to a solution for my problem is highly appreciated!

Cheers,

Marvin

Re: Elements having root-parent element with certain attribute in Listbox

Gysbert_Wassenaar — Sat, 20 Aug 2016 15:04:37 GMT

Please post a small qlikview document that illustrates the problem.

Re: Elements having root-parent element with certain attribute in Listbox

svinnakota — Sat, 20 Aug 2016 15:17:56 GMT

Hello Marvin,

Can you please post the example so that we can try to help you in resolving the issue and try to attach the output which you are looking for.

Re: Elements having root-parent element with certain attribute in Listbox

swuehl — Sat, 20 Aug 2016 21:28:45 GMT

I think you can use the HIERARCHY resp. HIERARCHYBELONGSTO LOAD prefixes to create a model that serves your need.

Hierarchies

Something like

Set NULLINTERPRET = '';

INPUT:

LOAD *, If(Len(Trim(ParentID))=0 and AttributeA = 'A', 1) as Flag INLINE [

ParentID, NodeID, AttributeA, Name

, 1,A, Parent 1

1,2,B, A child

1,3,C, B child

2,4,A, C child

, 5, B, Another parent

5,6, A, D child

];

Hierarchy(NodeID, PID, NodeName, Parent, NodeName, Path)

LOAD ParentID as PID, NodeID, Name as NodeName

RESIDENT INPUT;

HierarchyBelongsTo( NodeID, PID2, Name2, PID2, Ancestor)

LOAD ParentID as PID2, NodeID, Name as Name2

RESIDENT INPUT;

Left JOIN

LOAD NodeID as PID2, Flag as Flag2 RESIDENT INPUT;

Then you can create your list box with the treeview style and filter using Flag2:

=Aggr(Only({1<Flag2 = {1}>}Path), Path)

Re: Elements having root-parent element with certain attribute in Listbox

Tue, 23 Aug 2016 00:49:30 GMT

Thanks, Stefan! Works perfectly fine!