topic Re: Re: Rangesum in QlikView

Rangesum

thomas_skariah — Mon, 11 Nov 2013 08:15:22 GMT

Hi,

Can anyone suggest on this.See table below

I have a calculated column Cumulative where im using rangesum

=RangeSum(before(Sum(Value),0,ColumnNo()))., with this expression it calculates the value for nov dec and jan whereas i have data only till oct, so nov dec and jan should show blank.

For reference pls see attach application.

Item	Month	Value	Cummulative
A	Mar - 2013	10	10
A	Apr - 2013	1	11
A	May - 2013	14	25
A	Jun - 2013	2	27
A	Jul - 2013		27
A	Aug - 2013		27
A	Sep - 2013	4	31
A	Oct - 2013	98	129
A	Nov - 2013
A	Dec - 2013
A	Jan - 2014

Thanks

Regards,

Tom

Re: Rangesum

kaushiknsolanki — Mon, 11 Nov 2013 08:32:25 GMT

Hi,

Have a look at the application.

Regards,

Kaushik Solanki

Re: Re: Rangesum

thomas_skariah — Mon, 18 Nov 2013 06:54:07 GMT

Hi Kaushik,

Thanks for your help.

But didn't achieved what I looking for.Here in your attach application the Month year showing only till Oct'13 ,in my case it should also show Nov,Dec and Jan as Blank.

Regards,

Tom