Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a source file, from this source file I need to create a new table with grouping condition applied.
Grouping Condition is that if records having the same Order list,Airport and Consignee number is found then we should the records in to one.
I have attached the source file and file with expected results.
Would be helpful if this can be done.
Go to Solution.
Replace the last three dimension in your straight table with measures:
concat([Consignment Number], ',')
Thanks for the feedback, but how to make the comparison as I need to concat the Consignment number only if columns Order List, Airport and Consignee is same between two rows. If this condition is not met then the grouping should not be done.
Thank you for the solution. It works fine🙂