topic Average last three days except Sunday in QlikView

Average last three days except Sunday

Anonymous — Wed, 03 Jun 2015 16:42:30 GMT

Hi because of your help in my last discussion I set the following expression in order to get the average of sales in the last 3 three days given a particular date vDateRotura

 sum({<CalendarDate={">=$(=max(date(vDateRotura-3)))<=$(=max(date(vDateRotura-1)))"}> }  VENTAS.Peso)
/Count(DISTINCT {<CalendarDate={">=$(=max(date(vDateRotura-3)))<=$(=max(date(vDateRotura-1)))"}> }  CalendarDate)

Now what I would like to achive is the same expression but excluding the sundays. E.g. If the given date falls on Thrusday I want the average of previous Friday+Saturday+Monday.

Any ideas?

Thanks in advance

Re: Average last three days except Sunday

rakesh_kumar — Wed, 03 Jun 2015 16:51:39 GMT

Hi add this in the set analysis:

weekday(vDateRotura)={*}-{7}

Re: Average last three days except Sunday

Anonymous — Wed, 03 Jun 2015 17:07:57 GMT

Sorry Rakesh, I don't know exactly how to do it. Could you please lead me?

Thank you

Re: Average last three days except Sunday

rakesh_kumar — Wed, 03 Jun 2015 17:18:06 GMT

Hi,

Due to restrictions on the system I am replying this thread I am unable to copy and paste your whole expression here, but it will will be something like this:

Sum({<CalendarDate={" ..."}, weekday(vDateRotura) = {*}-{7}>} ventas.peso)

/ Count(Disctinct {<CalendarDate={"..."}, weekday(vDateRotura)={*}-{7}>} CalendarDate)

Re: Average last three days except Sunday

Anonymous — Wed, 03 Jun 2015 17:45:41 GMT

It doesn't work. Maybe I'm doing something wrong. I didn't say that vDateRotura is a variable. Thank you anyway.