How do I set a static filter on a chart to only show the information for a max date?
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):