I have a calendar table in qlikview which consist of date, month, quarter, year values.
In qlikview dashboard I need to display month names in multi box.
The requirement is like:
> If the current month is June, then I need to display month names like: June, May, Apr, March, Feb, Jan............till July month of previous year.
So, I need to display all 12 months which consist of month names between current month and January month of current year and from December of the previous year to (current month plus one) month of previous year.
Please help if any logic is there or please provide any hint in this.