Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist III
Specialist III

Re: Sum of Rows

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

View solution in original post

12 Replies
Highlighted
Champion III
Champion III

Re: Sum of Rows

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

expression as

= Sum(BOMITEMQty)

Highlighted
Specialist
Specialist

Re: Sum of Rows

Hi,

sum(TOTAL BOMITEMQty)

Highlighted
Specialist III
Specialist III

Re: Sum of Rows

Just use two text box:

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

Highlighted
Contributor III
Contributor III

Re: Sum of Rows

Thanks Vishwarath, unfortunately i still get a 6

Highlighted
Contributor III
Contributor III

Re: Sum of Rows

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

Highlighted

Re: Sum of Rows

Where are you trying this?

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)
Highlighted
Contributor III
Contributor III

Re: Sum of Rows

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

Highlighted
Contributor III
Contributor III

Re: Sum of Rows

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

Highlighted
Specialist III
Specialist III

Re: Sum of Rows

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

View solution in original post