7 Replies Latest reply: Jul 24, 2018 9:17 AM by Sunny Talwar RSS

    Two dates Filtering

    Raman Singh

      Hi,

       

      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:

       

      =date(FLOOR(MonthEnd(CreatedDate)),'MMMYYYY')

      =date(FLOOR(MonthEnd(DispatchDate)),'MMMYYYY')


      =count(distinct OrderID)

       

      MonthYear (CreatedDate)OrdersCreated
      Nov-201710
      Dec-201715
      Jan-20185
      Feb-201820

       

      MonthYear (DispatchDate)OrdersDispatched
      Nov-20175
      Dec-20172
      Jan-201815
      Feb-201810

       

      How would I go about creating a year filter for the above tables in Qlik Sense?

       

      Thank you in advance for any help.