topic Re: Grouping of a column in straight table in App Development

Grouping of a column in straight table

Venthan — Thu, 23 May 2019 13:06:18 GMT

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.

Re: Grouping of a column in straight table

Gysbert_Wassenaar — Thu, 23 May 2019 13:33:10 GMT

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

concat([Consignment Number], ',')

concat([Order Number],',')

sum([Total Weight])

Re: Grouping of a column in straight table

Venthan — Fri, 24 May 2019 04:50:37 GMT

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.

Re: Grouping of a column in straight table

Gysbert_Wassenaar — Fri, 24 May 2019 09:14:11 GMT

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.

Re: Grouping of a column in straight table

Venthan — Fri, 24 May 2019 09:28:06 GMT

Thank you for the solution. It works fine🙂