Dates in set analysis between two weekdays

Anonymous — Tue, 25 Oct 2011 12:27:47 GMT

Hi,

I want data between two dates in a set analysis and the dates is foun between num(weekday(Date)) >= 0 and num(weekday(Date)) <= 3.

I can't get it to work. This was my try:

sum({$<Year= , Month= , Date= {'>=$(=num(weekday(Date))= 0) <= $(=and num(weekday(Date))=3)'}, Årvecka = $(ThisWeek-1) >} Points)

//A.

jolivares — Tue, 25 Oct 2011 13:59:12 GMT

Try this...

sum({$<Year= , Month= , Date= {">=$(=num(weekday(Date))= 0) <= $(=num(weekday(Date))=3)"}, Arvecka ={$(ThisWeek-1)}>} Points)

topic Dates in set analysis between two weekdays in QlikView