If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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?
Thank you in advance for any help.
Thanks for the feedback guys.
I have had a read about Canonical Date but not sure if this works in my case, as I have one script in data load editor but then create two tables in NPrinting.
Orders table = contains CreatedDate and Dispatch Date
Table 1 = CreateDate, Orders
Table 2 = Dispatch Date, Orders
Does Canonical date not merge two separate tables in the data load editor?
So can I create two separate scripts (1.CreatedDate, 2.DispatchDate)
You mean two separate tables, right? If that is what you mean... then yes... Else, I am not sure what you mean when you say two separate scrips?
then follow Canonical date?