topic Re: Sum of Rows in QlikView

Sum of Rows

nedcliqs — Fri, 01 Dec 2017 20:29:51 GMT

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 item

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

Re: Sum of Rows

vishsaggi — Fri, 01 Dec 2017 20:34:25 GMT

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

expression as

= Sum(BOMITEMQty)

Re: Sum of Rows

el_aprendiz111 — Fri, 01 Dec 2017 20:43:29 GMT

Hi,

sum(TOTAL BOMITEMQty)

Re: Sum of Rows

sergio0592 — Fri, 01 Dec 2017 20:48:29 GMT

Just use two text box:

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

Re: Sum of Rows

nedcliqs — Mon, 04 Dec 2017 09:36:44 GMT

Thanks Vishwarath, unfortunately i still get a 6

Re: Sum of Rows

nedcliqs — Mon, 04 Dec 2017 09:37:21 GMT

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

Re: Sum of Rows

Anil_Babu_Samineni — Mon, 04 Dec 2017 09:38:34 GMT

Where are you trying this?

Re: Sum of Rows

nedcliqs — Mon, 04 Dec 2017 09:39:15 GMT

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

Re: Sum of Rows

nedcliqs — Mon, 04 Dec 2017 09:47:46 GMT

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

Re: Sum of Rows

sergio0592 — Mon, 04 Dec 2017 10:50:04 GMT

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

Re: Sum of Rows

Anil_Babu_Samineni — Mon, 04 Dec 2017 11:30:35 GMT

If you have only one dimension and that dimension used for aggr in measure you will always get 6.00

Use document number field also within the aggregation to work

Re: Sum of Rows

nedcliqs — Mon, 04 Dec 2017 12:04:44 GMT

Thank you very much @ jean-baptiste‌, the Aggregation function. Not only on the Text Object, but also on the Straight and Pivot tables

Re: Sum of Rows

nedcliqs — Mon, 04 Dec 2017 12:08:18 GMT

sum( AGGR(sum(BOMITEMQty),[Document No_]) ) as suggested by @ Jean-Baptiste RENAULTworked

Thank you all for your help.