Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to assign elements to hierarchized groups?

Hello everyone!

My question concerns the following task:

I have a list with different elements and their specific properties (Table1).

ElementPropertyProperty_Value
E1a3
E1b1
E1c1
E2...

These elements should now be assigned to groups with defined requirements (Table2). Depending on the individual properties it is possible that one element meets the requirements of more than one group.

GroupRequired_Property
G1a>=3
G2a>=2
G3a>=1
G4b>=2
G5b>=1
G6y>=0,5
G7c>=1

Anyhow the groups are partial hierarchized, what means that one element must not be assigned to more than one group in the same hierarchy but has to be matched with the group with the highest hiearchy-level.

The hierarchy of the groups is provided in the following structure (Table3):

Column AColumn B
G1G2
G1G3
G2G3
G4G5
G6G7

If one element meets the requirements of two groups in one row of Table3 it has to be assigned to the group in column A.Thus there are three hierarchies (H1 with G1, G2, G3; H2 with G4, G5; H3 with G6, G7).

So in this example Element E1 should be asigned to group G1, G5 and G6.

The goal is to assign every element to its fitting groups.

As a sophomore in the world of QV I'm kind of overstrained with this task and have no idea where to start. Existing threads to hierachy function weren't that helfpul for me.

I would be very grateful for any kind of help!

Greetings,

nepberger

Community Browser