Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rammuthiah
Contributor II

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
New Contributor II

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

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

7 Replies
krishna_2644
Valued Contributor III

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

Check the attached qvf.

result:

1.PNG

rammuthiah
Contributor II

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

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

krishna_2644
Valued Contributor III

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

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

rammuthiah
Contributor II

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

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

ChennaiahNallani
Contributor III

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

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
New Contributor II

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

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
Contributor II

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

Thanks

Community Browser