Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Dates in set analysis between two weekdays

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.

1 Reply
jolivares
Specialist
Specialist

Try this...

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