Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Default Selection in the Multibox

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.

Thanks,

Ram.

1 Solution

Accepted Solutions
Not applicable
Author

Hi Ram,

Hope the attached file help you to select the default values.

Thanks,

Raghu.

View solution in original post

3 Replies
Not applicable
Author

Hi Ram,

Hope the attached file help you to select the default values.

Thanks,

Raghu.

Not applicable
Author

Thanks Raghu..It's workling for me.

Not applicable
Author

Hi There,

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.

Kind Regards

Gerard