topic Re: Full Accumulative Issue in QlikView

Full Accumulative Issue

Tue, 17 Mar 2015 18:59:50 GMT

Hi,

I have more than one dimension, when I select full accumulation it is not working as expected and I read few post that need to use range sum function, but I have difficult formula not sure how to use rangesum, pls guide me below is the formula.

=if([Cost]<=0,0,sum({$<Nm_D_Dt = {">=$(vStartDate)<=$(vEndDate)"},M_Com=>}Sales)

sum({$<Nm_D_Dt = {">=$(vStartDate)<=$(vEndDate)"},M_Com=>}TOTAL Sales))

Thanks,

Re: Full Accumulative Issue

MK_QSL — Tue, 17 Mar 2015 19:36:28 GMT

Difficult to fully understand your formula without knowing your application but you can try below

=if([Cost]<=0,0,

RangeSum(Above(sum({$<Nm_D_Dt = {">=$(vStartDate)<=$(vEndDate)"},M_Com=>}Sales),0,Rowno()))

sum({$<Nm_D_Dt = {">=$(vStartDate)<=$(vEndDate)"},M_Com=>}TOTAL Sales))

Re: Full Accumulative Issue

Tue, 17 Mar 2015 20:09:07 GMT

Thanks for the response, but didn't worked the formula.

Thanks,

Re: Full Accumulative Issue

MK_QSL — Tue, 17 Mar 2015 20:13:04 GMT

Can you please provide sample apps or sample data to work similar to your apps.

Re: Full Accumulative Issue

Tue, 17 Mar 2015 20:35:17 GMT

It is one of my project formula, what I am trying to do is that I need full accumulative and I have more than one dimension, so my above formula is not showing full accumulative values. when I do some sample data I get perfect but this formula not sure how to use range function.

Thanks,