Discussion board where members can get started with Qlik Sense.
I have below source and I am expecting the output pasted in the bottom.
ProductList| Category| Date
] (delimiter is '|')
The ProductList field contain, list of products separated by comma.
These Products belong to 2 groups of categories, ie 100 and 200.
My requirement is, whenever the Date is >= 01/01/2016, I want to move the product 'XX'(from ProductList field) from category 200 to 100.
Go to Solution.
Concat(ProductList, ',') as ProductList,
Group By Category, Date;
If( Date>='1/1/2016' and ProductList='XX' and Category=200, 100, Category) as Category;
LOAD SubField(ProductList, ',') as ProductList,
Thanks at lot