Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Venthan
New Contributor II

Grouping of a column in straight table

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.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Grouping of a column in straight table

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

concat([Consignment Number], ',')

concat([Order Number],',')

sum([Total Weight])


talk is cheap, supply exceeds demand
4 Replies
MVP & Luminary
MVP & Luminary

Re: Grouping of a column in straight table

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

concat([Consignment Number], ',')

concat([Order Number],',')

sum([Total Weight])


talk is cheap, supply exceeds demand
Venthan
New Contributor II

Re: Grouping of a column in straight table

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.

MVP & Luminary
MVP & Luminary

Re: Grouping of a column in straight table

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.

talk is cheap, supply exceeds demand
Venthan
New Contributor II

Re: Grouping of a column in straight table

Thank you for the solution. It works fine🙂