First value selection from listbox

[koushik_btech20]

I have an problem regarding list box selection of a sheet. The problem is first value of the list box will be get selected automatically after going on these sheet. If anyone have any solution then share here...

[#2]

Go to sheet properties and have a look at the triggers. If something is changing between sheets it is most probably created in there. Otherwise go to Document Properties and have a look there as well

Cheers,

Byron

[#3]

Hi

Go to settings->Document properties->Sheets->Properties->Triggers->Check in On Load Triggers is there any such triggers activated on the sheet ->If then remove it

[koushik_btech20]

I am sorry for not posting my problem clearly. The problem is I have a list box in a sheet and  have to do the first value selection from the listbox after going to the sheet(onactivesheet). 

[#5]

Hi

go to sheet properties>triggers>onactivatesheet and then Add Select in Field Action and chose your field and value

[#6]

Hi,

You can achieve this by Always one selected values in the list box properties

Or you can write the trigger like this

On active sheet trigger

Go to Actions->Selection->Select in fields ->Specify the field name and give the value to be selected

[qlikpahadi07]

Hi koushik.btech2008

Try FirstSortedValue() function it's easy and you can achieve this