topic Re: avg a pivot chart data in QlikView

avg a pivot chart data

Mon, 09 Jun 2014 05:08:56 GMT

I have a field called month and i need to avg the last two months data and the last two months data and next month data and so on how can i do this

Re: avg a pivot chart data

tresB — Mon, 09 Jun 2014 05:12:42 GMT

You could try something like:

=rangeavg (above(Sum(x),0,1))

Re: Re: avg a pivot chart data

Mon, 09 Jun 2014 05:43:46 GMT

hi,

but i am not getting the exact answer

PFA

Re: avg a pivot chart data

tresB — Mon, 09 Jun 2014 05:55:21 GMT

Small correction:

=rangeavg (above( Sum(MARC_FinMonth),0,2))

Re: avg a pivot chart data

Mon, 09 Jun 2014 06:10:51 GMT

there is no difference between both the statements, the data for both the statements are same

there is any error in the above expression that calculates the sum of monthend inventories

Re: Re: avg a pivot chart data

tresB — Mon, 09 Jun 2014 06:26:22 GMT

PFA. Isn't this what you want?

Re: Re: avg a pivot chart data

Mon, 09 Jun 2014 10:06:27 GMT

hi that works well but i have a another question to u

question is that i have three fields LABST, UMLME, 3pl stock i need the monthend closing stock for this fileds and i have a condition for 3pl stock i.e

RecieveDate <= MonthEnd & GRDate = “ ” or > MonthEnd