Discussion Board for collaboration related to QlikView App Development.
I have Year and Month in the multi Box. In the year i have 2009 and In the month li have Jan,Feb.Mar,Apr and May.
Now every time if the user open the dashboard, the selection in the Multibox should be the current month i.e., May (if i open today).
If any one opens in the next month,selection of the month would June.
Please help how to get the solutiion for this. Or if this is not possible at least any of the month selection will do for me.
Go to Solution.
Hope the attached file help you to select the default values.
View solution in original post
Thanks Raghu..It's workling for me.
I have a field called "DayStarted" on pressing a button or changing to another Tab i would like the highest value to be returned, Ive looked at the above document but having problems implementing it.
The Macro has been changed to
Sub selectLatestDate"DayStarted"). Select ActiveDocument.Evaluate("max(ALL DayStarted)")End Sub
On pressing the button the selections for the Date field don't appear to change. Any advice would be greatly appreciated.