Define the groups within one list

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I have to define several groups of items within 1 list. It is a kind of a shortened hierarchy.

I have made it like this:

ListOfItems:

Hierarchy(%Item,%Pre-Item,Item)

LOAD

%Item,

%Pre-Item,

Item

FROM

[$(vPath)....qvd]

(qvd);

Group_List:

Load

%Item

, 1 as %Group

Resident ListOfItems

where Item1= 'Fanta' and Exists(Item2);

Concatenate

Load

%Item

, 2 as %Group

Resident ListOfItems

where Exists(Item4) and Item3= 'Chocolate';

Drop Table ListOfItems;

Left Join (Items_Full_List)

Load

%Item

, %Group

Resident Group_List;

DROP Table Group_List;

DefinedGroups:

Load * Inline

[%Group, Group

1, Fanta

2, Chocolate];

It works good. But now I need to define a group of NON_FANTA Items, which makes an intersection with Chocolate Items. What I want to have in visualization is a filter with 3 rows: Fanta, Chocolate and NON-Fanta. I came to making 2 different fields for Fanta & NON-Fanta and Fanta & Chocolate, but it is not what I really need.

Please help. I appreciate.

Kind regards

Elena

Re: Define the groups within one list

el_aprendiz111 — Sat, 08 Oct 2016 18:22:15 GMT

Hi,

Would you be able to share a sample data?

Re: Define the groups within one list

sfatoux72 — Sat, 08 Oct 2016 22:15:00 GMT

‌HI,

If you want to do Intersection of Group, you could try to use AND-mode in List Boxes ‒ QlikView

Read well the help page because you need to respect some criteria to use it

regards

topic Re: Define the groups within one list in QlikView

Define the groups within one list

Re: Define the groups within one list

Re: Define the groups within one list