Comments Logic from multiple cells into a single cell based on grouping

[rammuthiah]

I have some projects which are having some customer feedback(positive/negative). I want to group it based on customerID in a straight table Qlik Sense. Is there any way?

Input :

CustID	Positive feedback	Negative feedback
1	Service is good	Product is not worthy
1		Rate is high compare to other online shops
2	Nice Product
2		Late Delivery

Need Output as like below :

CustID	Feedback
1	Positive : Service is good Negative : Product is not worthy, Rate is high compare to other online shops
2	Positive : Nice Product Negative : Late Delivery

[Qrishna]

Check the attached qvf.

result:

[rammuthiah]

Instead of separate row, need this in a single cell based on CustID

[Qrishna]

you've mentioned straight table and its not possible in straight but u can achieve it with pivot table.

[rammuthiah]

It's possible. I have done this earlier, but forgot now

[ChennaiahNallani]

Try like this

CrossTable(feedback,Comments)

Load * Inline [

CustID,Positivefeedback,Negativefeedback

1,Service is good,Product is not worthy

1,'',Rate is high compare to other online shops

2,Nice Product,''

2,'',Late Delivery

];

[nivethitha · Accepted solution]

Hi,

Please find the attached qvf.

wrapping statements in a single cell is not possible rather you can separate positive and negative feedback with a semicolon.

However, on hovering the message will display both +ve and -ve feedbacks in a separate lines.

[rammuthiah]

Thanks