
How to sum all the values in a column
Rakesh Mehta May 20, 2011 5:54 PM (in response to mm311ton)You somehow need to wrap whole thing with a SUM(), then it will sum the column values.
Since you are using SUM() already, SUM() within a SUM() will not work.
Look into AGGR() functions and play with it a little. I am sure that would work.
What would help if you upload a sample document here.

Re: How to sum all the values in a column
erich shiino May 20, 2011 7:05 PM (in response to mm311ton)Not sure, if I got you, but I think everything was simpler.
Please, check my app

cats and dogs.qvw 135.0 K


Re: How to sum all the values in a column
Rakesh Mehta May 20, 2011 7:13 PM (in response to mm311ton)
Re: How to sum all the values in a column
mm311ton May 23, 2011 9:54 AM (in response to Rakesh Mehta)This got my halfway there. It did make QlikView show the sum of the rows. However now I need to reuse that value elsewhere. Thanks for the ideas thus far  I sincerely appreciate your time and effort trying to help solve this matter.

Re: How to sum all the values in a column
Gregor Spychala May 23, 2011 10:13 AM (in response to mm311ton)Hi,
if you want to use this value in the same table try the following formula:
sum(total {<House=>} Dogs)/sum(total {<House=>} Cats)

Re: How to sum all the values in a column
erich shiino May 23, 2011 10:36 AM (in response to mm311ton)If you get the expression as it is, does it work?
I guess it depends where you use it, but you can write something like:
sum ( aggr( sum(Dogs)/suM(total Cats), House))

Re: How to sum all the values in a column
mm311ton May 23, 2011 10:56 AM (in response to erich shiino)This worked. That you for your tremendous help. I was stuck on this for a long time and can now continue with my project. Thank you so much!



Re: How to sum all the values in a column
qlik_techie Mar 16, 2012 6:48 AM (in response to Rakesh Mehta)Hi,
i think you can solve my problem again.
i've dimemsions dim1,dim2,dim 3..in hierarchial format as in pivot table.
i've a value column in the table, as one expr....i'm showing sum(value) and i also have dimension due date....& if the due date <today() date then in the expr column Overdue Amt i simply show sum(value) else i'll show it the Not due column...this is fine....
now i've to find %Overdue & %Not due.....wich is Overdue Amt/sum(value) & Not Due Amt/sum(value) respectively...
i'm getting the % fine..for each row...but at the total level i dnt want to see sum of all % for Overdue & %Not Due
Bt only the sum of Overdue Amt/sum of Remainin Amt & same for %Not due as well
Plz help
stuck for 1 day cmplete
Regards
