topic set analysis 3 day avg in QlikView

set analysis 3 day avg

Anonymous — Thu, 06 Feb 2014 15:37:16 GMT

Hi all

i have a table that looks like this dates and number of sales

i need to show a graph for each day the avg sale amount of the 3 prev days

for example on the 23/12/13 the Avg3DaySale will be (5+5+5)/3

22/12/13 the Avg3DaySale will be (5+5+6)/3

my big limitation is that i cant do this in the script i have to do this with a set analysis in the gui

any ideas?

giakoum — Thu, 06 Feb 2014 15:39:23 GMT

You can use the above function. But if today is Monday, should it average Thu, Fri and Mon?

giakoum — Thu, 06 Feb 2014 15:40:39 GMT

This is a better solution. See attached

maxgro — Thu, 06 Feb 2014 15:58:30 GMT

do you mean a similar expression?

RangeAvg( above( sum(Sale),0,3) )

giakoum — Fri, 07 Feb 2014 08:12:52 GMT

yes correct

Anonymous — Tue, 11 Feb 2014 13:47:41 GMT

it doesn't work if i have 2 dimensions

Anonymous — Tue, 11 Feb 2014 13:56:28 GMT

like if i have something like this

the 2 day sum col will sum up by date and category

Rangesum( above( sum(Sales),0,2) )

Tue, 11 Feb 2014 14:10:03 GMT

Hi Jonathan,

Check this link you will get clear idea about rangesum and rangeavg .

regards

Mahesh T