Hi Qlik,
A table showing which days a site has deliveries of which looks at little like this:
Site | Delivery days |
---|
A | 1,2 |
B | 2,3 |
C | 4 |
D | 1,3,5 |
I want to build a table that says whether or not a site has deliveries on a day. I want the table to look like the below (with a filter on for Site A).
I am using the equation:
if(weekday(BlankDate)=
(if(wildmatch([Preferred Scheduled day],'*1*'),'Mon',
if(wildmatch([Preferred Scheduled day],'*2*'),'Tue',
if(wildmatch([Preferred Scheduled day],'*3*'),'Wed',
if(wildmatch([Preferred Scheduled day],'*4*'),'Thu',
if(wildmatch([Preferred Scheduled day],'*5*'),'Fri')))))),'y','n')
However this only returns the 01/01/1991 as 'y' the next day is a no.
Can anyone please help or come up with a better solution?
Date | Day | Delivery |
---|
01/01/1991 | mon | Y |
02/01/1991 | tue | Y |
03/01/1991 | wed | n |
04/01/1991 | thu | n |
05/01/1991 | fri | n |
06/01/1991 | sat | n |
07/01/1991 | sun | n |