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.
