Grand Total for 3 invoices

[nedcliqs]

Hi All

I need a Grand Total in a List box for 3 invoices whose quantities are identical like below:

INVOICE #                     QUANTITY in KGs

inv01                                   22.68

inv02                                  22.68

inv03                                   22.68

Since the quantity is a repeated value, Qlikview only shows 22.68

What i want is a list box that sums the quantities such that the list box shows 68.04 is Total Quanity

I have tried Aggr(Sum(Quantity), [Invoice #]) but i am getting all kinds of answers

I am really knew to Qlikview so if you may help with as much explanation as possible

Thanks

Ned

[sunny_talwar]

Is this in a list box object? May be this:

Sum(TOTAL Quantity)

[nedcliqs]

Thanks Sunny, but still that is giving me the same wrong answer as Aggr(Sum(Quantity), Invoice#).

[sunny_talwar]

Would you be able to share a sample?

[nedcliqs]

I have realized that my JOINS seem to be creating duplicates. I did a Count(Invoice#) and I am getting 7 instead of 3. Let me fix that first and I will let you know

Thank you very much.

[arasaraja_cts]

Hi,

I believe you are trying with Invoice # as dimension and Sum(QUANTITY ) as Expression in your list box.

As far I know, you will never get 68.04 in a list box,moreover by doing Aggr it will again give output grouped by Invoice#.

You can use use a text box with Sum(Quantity) to get 68.04, or create a table and at the bottom you can get total value as 68.04.

Thanks

Raja