6 Replies Latest reply: Sep 6, 2016 4:32 AM by Jermaine Ramsaransing RSS

    Limit filter values

    Jermaine Ramsaransing

      Dear experts,

       

      I have a filter that is based on quarters.

       

      periode-filters.PNG

      The expression code is: QuarterName(reportingdate, 0).

      "reportingdate" is a Qlik date.

       

      But I want to limit the filters, I want only to see the current quarter, that the end-user is at when they open the qlik app, at time of writing this is "Jul-Sep 2016", -1, -2, -3.

      So the end result will be this, notice that "Oct-Dev 2016" is gone in the image below:

       

      periode-filters-limit.PNG

      How can I achieve this? Couldn't find good examples via the search/google.