Discussion board where members can get started with Qlik Sense.
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?
Service is good
Product is not worthy
Rate is high compare to other online shops
Need Output as like below :
Positive : Service is good Negative : Product is not worthy, Rate is high compare to other online shops
Positive : Nice Product Negative : Late Delivery
Go to Solution.
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.
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
Load * Inline [
1,Service is good,Product is not worthy
1,'',Rate is high compare to other online shops