topic Re: get last selected value from listbox? in QlikView

get last selected value from listbox?

Sat, 01 Mar 2014 11:25:31 GMT

Hi,

I want to be able to get the last value that is selected in the listbox. I want to force the listbox to only select the value that was last selected and clear other value if a user makes multiple selections. I basically want to force the user to only make one selection. I used the below code in the onanyselect trigger

=subfield(GetFieldSelections(EmployeeName),',')

However this expression only selects the first value in the alphabetical order of selections. I want to force the trigger to only select the value that was selected in last and clear the other values.

I am using this trigger and not the always one selected value property because I want to clear this property when I move to other sheets

Arif

Re: get last selected value from listbox?

CELAMBARASAN — Sat, 01 Mar 2014 11:41:22 GMT

You can make the list box to always one selected.

Which is there in the listbox properties-->General-->Check the always one selected

Re: get last selected value from listbox?

Siva_Sankar — Sat, 01 Mar 2014 11:46:14 GMT

Syed,

Looks like the requirement is discussed here. http://community.qlik.com/thread/58278

You can try set analysis or bookmark feature. Check the above mentioned link.

Regards.

Siva

Re: get last selected value from listbox?

Sat, 01 Mar 2014 11:51:43 GMT

by last, I mean the value that was selected at the end. For example, If you make multiple selections, then the value that was selected last should be selected while the others should be cleared. Bookmark will only take me to previous selections.

What I want is an alternate to always one selected value. I don't want to use the always one selected value property because I want to clear the field when I move to other sheets.

So I want to use the onanyselect trigger and clear the multiple selections and only keep the value that was selected last.

Bookmark will take me to all the selections that were made previously

Regards

Syed

Re: get last selected value from listbox?

Sat, 01 Mar 2014 11:52:26 GMT

can't use always one selected value property because I want to clear the field when I move to other sheets

Arif

Re: get last selected value from listbox?

CELAMBARASAN — Mon, 03 Mar 2014 06:52:46 GMT

Here you need some kind of trigger

Hope below workaround works

Goto Document properties - > Trigger -> Field Event Trigger-->Select a Field "EmployeeName".

Add Action for On Select event-->chose Select in Field Action in the Selection category.

in Field type Field name i.e., EmployeeName

in Search string use

=if(GetActiveSheetID()='Document\SH01', if(GetSelectedCount(EmployeeName) = 0,MaxString({$1} EmployeeName), MaxString(EmployeeName)), '(' & Concat(DISTINCT EmployeeName, '|') & ')')

Assuming that 'Document\SH01' sheet id needs atleast one selected functionality.

But when coming to same sheet again you need to use sheet trigger to do some work around.