15 Replies Latest reply: Aug 4, 2018 8:15 AM by Manikantan S RSS

    Exclude Filter from Affecting Chart when filter dimension is an expression

    Manikantan S

      Hi All,


      In my date filter field, i am displaying only the latest closed month (Idea is to toggle between full year view and recent month view).


      i am using an expression as follows:


      =if(Month(Closeddate) = vMaxMonth and Year(Closeddate) = vMaxYear, vMaxMonth)


      I have created variables vMaxMonth & vMaxYear in the load script to get the month and year of the maximum closed date.


      Now, my requirement is that i dont want this filter to affect one chart alone. Hence i give the expression as:


      Count ({<Closeddate =>} [Application ID])


      But this does not work. If i had displayed all closed dates in the filter instead of the expression i have used, the above works.

      Is this a property of Qlik or do i need to use a different expression in place of the above to ensure that the filter is not considered?


      Yours Truly,