topic Has anyone tried to use Rangeavg function using Set analysis in QlikView

Has anyone tried to use Rangeavg function using Set analysis

bimala0507 — Thu, 30 Oct 2014 03:58:11 GMT

Hi:

Anyone having expertise in Set Analysis? I want to calculate Cumulative average against each Month and Year with 2 Years of Sales Data. Attached the Input file and QV file, if anyone can give an insight?

Kind Regards,

Bimala

Re: Has anyone tried to use Rangeavg function using Set analysis

jagan — Thu, 30 Oct 2014 04:10:07 GMT

Hi,

Can you explain your expected output for RangeAverage with an example.

Regards,

Jagan.

Re: Has anyone tried to use Rangeavg function using Set analysis

Kushal_Chawda — Thu, 30 Oct 2014 04:12:53 GMT

Do let me know what exactly you need with required output

Re: Re: Has anyone tried to use Rangeavg function using Set analysis

bimala0507 — Thu, 30 Oct 2014 04:59:03 GMT

Hi Jagan/Khush:

Please find attached the result excel sheet, I would like to achieve.

Basically I am trying to calculate the Moving average, so For Jan it is to be Jan (Amount) by 1 and for Feb it will be Jan(Amount) + Feb(Amount) /2 and so on and when the year changes it needs to be reset.

Kind Regards,

Bimala

Re: Re: Re: Has anyone tried to use Rangeavg function using Set analysis

tresB — Thu, 30 Oct 2014 05:06:56 GMT

Try:

=RangeAvg(Above(Sum(Amount),0, RowNo()))

Re: Has anyone tried to use Rangeavg function using Set analysis

jagan — Thu, 30 Oct 2014 05:11:25 GMT

Hi,

Try this expression

=RangeAvg Aabove(Sum(Amount),0, RowNo()))

Regards,

Jagan.