Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
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