orders made on same date or next date Qlik Sense

[joeybird]

Hi

I am trying to find out if orders from two different departments have been made on same day

I have been trying to write the following in the load statement, but it does not seem to work

please help

if (("OrderDate" and  "Department" = 'Furniture') = ("OrderDate" AND "Department" = 'Kitchen'), 'Yes', 'No') as DualOrder

but I also need to find out once this works how to see if someone has ordered from the Furniture department , but ordered the Same or Next Day from the kitchen department

please help

[joeybird]

hi

what can I say...awesome star as always

working brilliantly

thanks again