I am having some trouble working out how to create a filter on two different dates.
I currently have one script in my data load editor which contains CreatedDate and DispatchDate. These dates refer to when an order was created and when the order was dispatched. An order could have been created in 2017 or earlier and dispatched anytime after the created date.
Using these dates I have created summaries by month/year of orders created and orders dispatched:
App expression for MonthYear:
How would I go about creating a year filter for the above tables in Qlik Sense?