4 Replies Latest reply: Jun 19, 2018 7:05 AM by Prashant Sangle RSS

    Date filter for multiple tables

    Raman Singh

      Hi,

       

      I am new to Qlik Sense and have been given a project to work on, but having difficulty adding a date filter for tables. The 3 tables I have are all using different date columns but I would like to have ONE date filter, is this possible?

       

      FILTER: StartDate and EndDate

       

      Table 1:

      MonthYear (StockDate)Pieces Remaining
      Jan2018166
      Feb2018168
      Mar2018180
      Apr2018198

       

      Table 2:

      MonthYear (CreatedDate)Pieces In
      Jan201833
      Feb201829
      Mar201826
      Apr201839

       

      Table 3:

      MonthYear (OrderDate)Pieces Out
      Jan201816
      Feb20188
      Mar20185
      Apr201815

       

      If this is not possible how do I just set the dates to the previous monthyear? Is that done in the expression for 'MonthYear'?

       

      I managed to export the qvf file if this is useful?

       

      Thank you in advance for your help.