Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Galbatron316
Contributor
Contributor

If equal to multiple values based on day of week

Greetings to everyone:

 

I have an if statement that gets day of week, what I need is to select multiple results depending of day of week:

 

Sum({<[week] = {'$(=if(Weekday(today())='lun',Week(Date(Today()-1)),Week(Date(Today()))))'},Year={'$(=Year(Date(Today())))'},[Day of Week]=
{'$(=
if(Weekday(today()-1)='Mon',1,
if(Weekday(today()-1)='Tue',2,
if(Weekday(today()-1)='Wed',3,
if(Weekday(today()-1)='Thu',4,
if(Weekday(today()-1)='Fri',5,
if(Weekday(today()-1)='Sat',6,
if(Weekday(today()-1)='Sun',7))))))))'},
[Code]={'1010'},Day,Month,[Month number]
>}Sales)

I need to do this:

 

If(Weekday(today()-1)='Mon',(1,2,3,4).

 

How can I select more Results to solve my problem?

 

Kind Regards

1 Reply
Brett_Bleess
Former Employee
Former Employee

Best I have is the following Design Blog post that I think may help you sort things out, I will include the base URL below that which you can use to further search yourself if the one I am providing does not quite do the trick.

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.