Grouping of a column in straight table

[Venthan]

Hi All,

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.

[Gysbert_Wassenaar · Accepted solution]

Replace the last three dimension in your straight table with measures:

concat([Consignment Number], ',')

concat([Order Number],',')

sum([Total Weight])

[Venthan]

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.

[Gysbert_Wassenaar]

Either you didn't try my suggestion or I don't understand your question. If the latter please post a small Qlik Sense app that illustrates the problem.

[Venthan]

Thank you for the solution. It works fine🙂