Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nedcliqs
Contributor III
Contributor III

Sum of Rows

Hi Community

I have rows of data for an item but from different sales orders

Since the item description is the same, i want one line (in a straight or pivot table)  that will give me the a total sum for this itemSumRows.JPG

The correct quantity for the above should be 36

May you please help  on how i can have something like (Using a calculation)

BOMITEM_Description                    TOTALQUANTITY

Zipper Bag                                  36

1 Solution

Accepted Solutions
sergio0592
Specialist III
Specialist III

And if you try with :    sum( AGGR(sum(BOMITEMQty),Document_No) )

View solution in original post

12 Replies
vishsaggi
Champion III
Champion III

In your straight table chart Remove Document No_ from your dimensions and add

expression as

= Sum(BOMITEMQty)

el_aprendiz111
Specialist
Specialist

Hi,

sum(TOTAL BOMITEMQty)

sergio0592
Specialist III
Specialist III

Just use two text box:

left text box =GetFieldSelections (BOMITEM_Description)
right text box= sum(BOMITEMQty)

nedcliqs
Contributor III
Contributor III
Author

Thanks Vishwarath, unfortunately i still get a 6

nedcliqs
Contributor III
Contributor III
Author

Tried it, thanks, but still getting a 6 instead of 36

Anil_Babu_Samineni

Where are you trying this?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
nedcliqs
Contributor III
Contributor III
Author

Thanks Jean, Description pulls correctly but sum(BOMITEMQty) gives a 6

nedcliqs
Contributor III
Contributor III
Author

All the above suggestions, i have tried on a straight table. Jean's one, i have tried on a Text Object

sergio0592
Specialist III
Specialist III

And if you try with :    sum( AGGR(sum(BOMITEMQty),Document_No) )