Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
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?
and what expression do I require?
thanks
Gus
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.
Then the action on the button would be:
Action: Select a Value in Field
Field: MonthsFromCurrent
Value: >0<=6
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.
cheers, Gus