Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
2 | Positive : Nice Product |
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.
Check the attached qvf.
result:
Instead of separate row, need this in a single cell based on CustID
you've mentioned straight table and its not possible in straight but u can achieve it with pivot table.
It's possible. I have done this earlier, but forgot now
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
];
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.
Thanks