Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is this in a list box object? May be this:
Sum(TOTAL Quantity)
Thanks Sunny, but still that is giving me the same wrong answer as Aggr(Sum(Quantity), Invoice#).
Would you be able to share a sample?
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.
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