Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

bimala0507
Contributor

Has anyone tried to use Rangeavg function using Set analysis

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

5 Replies
MVP
MVP

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

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

Do let me know what exactly you need with required output

bimala0507
Contributor

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

@

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

MVP
MVP

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

Try:

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

MVP
MVP

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

Hi,

Try this expression

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

Regards,

Jagan.

Community Browser