Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rammuthiah
Creator III
Creator III

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

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

1 Solution

Accepted Solutions
nivethitha
Partner - Contributor II
Partner - Contributor II

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.293329.png

View solution in original post

7 Replies
krishna_2644
Specialist III
Specialist III

Check the attached qvf.

result:

1.PNG

rammuthiah
Creator III
Creator III
Author

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

krishna_2644
Specialist III
Specialist III

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

rammuthiah
Creator III
Creator III
Author

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

ChennaiahNallani
Creator III
Creator III

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

];

Capture.PNG

nivethitha
Partner - Contributor II
Partner - Contributor II

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.293329.png

rammuthiah
Creator III
Creator III
Author

Thanks