Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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