
Re: Running total / cummulative
Robert Hutchings Aug 12, 2012 7:42 AM (in response to anandab97253)Awful solution I know but it kind of works for a small number of categories. (I look forward to a better solution)
if(RowNo()=1,sum(Amount),
if(RowNo()=3,sum(Amount)+(above(sum (Amount),2))+above(sum(Amount)),
if(RowNo()=2,sum(Amount)+above(sum(Amount)),
if(RowNo()=4,sum(Amount)+(above(sum (Amount),2))+above(sum(Amount))+(above(sum (Amount),3)),
if(RowNo()=5,sum(Amount)+(above(sum (Amount),2))+above(sum(Amount))+(above(sum (Amount),3))
+(above(sum (Amount),4)),
if(RowNo()=6,sum(Amount)+(above(sum (Amount),2))+above(sum(Amount))+(above(sum (Amount),3))
+(above(sum (Amount),4))+(above(sum (Amount),5)),
if(RowNo()=7,sum(Amount)+(above(sum (Amount),2))+above(sum(Amount))+(above(sum (Amount),3))
+(above(sum (Amount),4))+(above(sum (Amount),5))+(above(sum (Amount),6))
,
0)))))))
I have just used (which has worked for me so far for my requirements)
SUM(TOTAL<Category>Amount)
to avoid the above but Im sure there is a much better solution (I just have not been able to work it out yet)

Re: Running total / cummulative
Robert Hutchings Aug 12, 2012 12:57 PM (in response to Robert Hutchings)This seems to work too (straight and pIvot tables)
RangeSum (above(sum(Amount),1,RowNo()1))+sum(Amount))
or
RangeSum (above(sum(Amount),0,RowNo()))

Re: Running total / cummulative
anandab97253 Aug 15, 2012 2:52 PM (in response to Robert Hutchings)RJ, could you please provide the solution in qlikview with the test excel attached
Kind Regards
Anand

Re: Running total / cummulative
Robert Hutchings Aug 19, 2012 5:11 AM (in response to anandab97253)Have you a problem with or difficulty understanding the solution

Re: Running total / cummulative
anandab97253 Aug 20, 2012 4:12 PM (in response to Robert Hutchings)RJ,
I have difficulty in understanding the solution and so requesting you to provide me the soultion in qlikview itself with the sample data I requested .. plz help
Regards
Anand

Re: Running total / cummulative
Robert Hutchings Aug 21, 2012 2:44 AM (in response to anandab97253)I used your excel sheet and loaded into QLIKVIEW
Then I see up a chart straight table (or chart pivot table)
Then I set up
dimensions.
Selected
Category and item
Expressions
sum (Amount)
SUM(TOTAL<Category>Amount)
RangeSum (above(sum(Amount),0,RowNo()))
You will need to sort in some way to get the order the same as your excel spreadsheet
I think this will work. I have done similar at work (I use sum total category) or need to do similar whihc I will use range sum etc

Re: Running total / cummulative
anandab97253 Aug 21, 2012 7:02 AM (in response to Robert Hutchings)Thanks a Ton RJ , It worked ,Thanks a Lot for ur help !!!

Re: Running total / cummulative
anandab97253 Aug 21, 2012 7:06 AM (in response to anandab97253)RJ,
could you please let me know whether is there any possibility to do the same, apart form using the rangesum function in pivot.
just wanted to know if at all if any please let me know
Kind Regards
Anand






