Skip to main content
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Qlik Sense Table- Merging rows

Hi All,

From the attached table snapshot, I have used the field Total Open Order Qty as a measure with the expression

= sum({<[Run Date]={"$(=Max([Run Date]))"}>}[Open Order Qty])

But as you see on the attached, the Total Open Order quantity for the particular sales document is repeating for all other measures related to a single sales document. 

Is there a way to merge the Total Open order qty for one sales document field value? 

Exact replica of the current table used is attached as a image- please look into this

Please help me with this problem.

Thank you

Labels (3)
1 Reply
Contributor III
Contributor III

@sunny_talwar  could you please help to resolve this. Thank you..