topic Auto selection on sheet open - First of Possible Values in QlikView

Auto selection on sheet open - First of Possible Values

Tue, 12 Jan 2010 16:15:00 GMT

Hi,

How can be defined that on a sheet activate event the first possible value of a specific field should be initially selected.

I was trying to go through the Sheet Settings - Triggers but didn't succeed.

Appreciate all the help you can give

Regards

Joao

Auto selection on sheet open - First of Possible Values

Tue, 12 Jan 2010 17:03:40 GMT

For the Sheet, set the OnActivate event to use a macro like this:

Sub Selector
 set fld = ActiveDocument.Fields("FIELD")
 set val = fld.GetPossibleValues
 fld.Select val.Item(0).Text
End Sub

I'm not sure if you can select the first possible using a trigger. You could probably create a variable that holds the first possible and then select using that. I'm back on 8.5, so I've been unable to use triggers for a while.

Auto selection on sheet open - First of Possible Values

Tue, 12 Jan 2010 23:44:26 GMT

Hi Miller,

Thank you for you promptly help.

The solution fits perfectly and the issue is solved.

Regards

Joao

Auto selection on sheet open - First of Possible Values

Wed, 13 Jan 2010 11:45:07 GMT

Hi Miller!

Hope you can give me some solution for me here.

http://community.qlik.com/forums/t/24345.aspx