Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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

Labels (1)
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.