I need to link an action to a navigation button (available under Qlik dashboard bundle in custom objects) that will trim my chart to show only the last 6mths, my date field is is format DD/MM/YYYY.
what action do a choose? e.g. multiple values in a field , select variable value?
Its been my experience that the Nav Button doesn't work with dates easily, so it makes it much easier if you add to your master calendar a field for MonthsFromCurrent using Round((num(monthstart(Today(1))-num(monthstart(Date(TempDate)))))/30) in the load script.
Thanks for that , I have attached an example file as I still have a few queries.
So I have a field called MonthsFromCurrent loading fine as part of master calendar, and have attached this to the nav button (select a value in field) as an action.
It is not linked with my mth dimension that I want to show on the chart, how do I do this so that my chart shows mths on the x axis rather than the number outputs 2-6 for MonthsFromCurrent?
The other problem is that is treating the data set as a whole due to mth not showing as a dimension on the chart, whereas I need to show the top left chart on my page (but with only the 2nd half of 2019)
