Discussion board where members can get started with Qlik Sense.
I am new to Qlik Sense and need help on below issue urgently.
I have a Table as follows:
I have field names Product Name in which there are different Products :
and i am looking for output like:-
|Custid||Products bought||Products not bought|
Actually in the Output of Products not bought I want all product name which are not bought by the Customer and they must be comma seperated.
Solved! Go to Solution.
Take a look at the concat() function.
1 as Flag;
LOAD * INLINE [
LOAD DISTINCT Items as AllItems
LOAD Distinct CustomID
AllItems as Items
Concat(If(Flag = 1, Items), ', ') as [Items Bought],
Concat(If(Flag <> 1, Items), ', ') as [Items Not Bought]
Group By CustomID;
DROP Tables Temp, Table;