topic Average Cumulative With 1 Value in QlikView

Average Cumulative With 1 Value

pgalvezt — Mon, 31 Mar 2014 18:31:16 GMT

Hello,

I´m Looking for a formula that can calculate the avg total in QlikView.

I have a count of names and months I need to show the cumulative average by month.

I put an excel file with what I want.

My Dimensio is Month

My Expression is Count(Names)

I need the cumulative average by month

Thanks...

jerem1234 — Mon, 31 Mar 2014 18:36:30 GMT

you can try:

rangeavg(above(count(Names), 0, rowno()))

Hope this helps!

MK_QSL — Mon, 31 Mar 2014 18:43:43 GMT

Check enclosed file...

pgalvezt — Mon, 31 Mar 2014 18:48:26 GMT

Hi Jerem,

How can I obtain the total (Annual)?

Thanks

MK_QSL — Mon, 31 Mar 2014 18:56:00 GMT

IF(Dimensionality()=0,Sum(Sales)/Count(Distinct Month), RangeAvg(Above(SUM(Sales),0,RowNo())))

jerem1234 — Mon, 31 Mar 2014 18:58:48 GMT

What do you mean by total (Annual)?

Do you mean the avg of all the months? You can get that with avg(total aggr(count(Names), Month)).

If you want it to appear in the total section of your column you are accumulating, you'll need to separate it out using dimensionality() like:

if(dimensionality()=0, avg(total aggr(count(Names), Month)), rangeavg(above(count(Names), 0, rowno())))

Hope this helps!