3 Replies Latest reply: Dec 19, 2017 8:44 PM by Sunny Talwar RSS

    How do I set a static filter on a chart to only show the information for a max date?

    Nick Otterman

      I've found some things indicating I need to do set analysis, and even found some syntax, but the challenge I'm running into is that my date field is in the format YYYY-MM.  I think that makes it a text field, and I believe using the max function isn't working properly.  Does anyone know how to do the syntax so that I can set an expression to only return the results for the max date?

       

      Here are the two attempts I've made so far (but I think I might be getting some Qlikview syntax mixed in here....I'm really new to this, so the syntax is a challenge for me):

       

      =Sum({<[Year-Month] = {"$(=Max([Year-Month])"}>}Count)

       

      =sum({<[Year-Month]={'=(max([Year-Month]))'}>}Count)