topic First value selection from listbox in QlikView

First value selection from listbox

koushik_btech20 — Sat, 21 Sep 2013 05:01:51 GMT

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...

Re: First value selection from listbox

Sat, 21 Sep 2013 05:58:57 GMT

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

Re: First value selection from listbox

Sat, 21 Sep 2013 06:05:29 GMT

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

Re: First value selection from listbox

koushik_btech20 — Sat, 21 Sep 2013 08:00:48 GMT

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).

Re: First value selection from listbox

Sat, 21 Sep 2013 09:31:17 GMT

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

Re: First value selection from listbox

Sat, 21 Sep 2013 09:44:19 GMT

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

Re: First value selection from listbox

qlikpahadi07 — Sun, 22 Sep 2013 09:08:56 GMT

Hi koushik.btech2008

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