topic Default Selection in the Multibox in QlikView

Default Selection in the Multibox

Fri, 29 May 2009 16:51:48 GMT

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.

Default Selection in the Multibox

Fri, 29 May 2009 16:56:38 GMT

Hi Ram,

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

Thanks,

Raghu.

Default Selection in the Multibox

Fri, 29 May 2009 22:50:29 GMT

Thanks Raghu..It's workling for me.

Default Selection in the Multibox

Mon, 21 Dec 2009 22:35:20 GMT

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