topic Re: ListBox - Always at least one Selected Value needed (not Always One Selected Value) in QlikView

ListBox - Always at least one Selected Value needed (not Always One Selected Value)

Tue, 31 Jan 2012 20:46:57 GMT

I want to have my Listbox (Qlikview 10.0 SR2) have the behavior or allowing many selections but always have at least one selected. I am aware of the Property "Always One Selected value", but this is not the behavior I want. I want "Always One or more selected values". How can I acheive this?

Re: ListBox - Always at least one Selected Value needed (not Always One Selected Value)

swuehl — Tue, 31 Jan 2012 20:56:34 GMT

You could use triggers in Settings - Document properties for a Field Event (OnChange and OnSelect) to achieve this.

For example, if your field is Month, select Action Select - Select in Field with field

Month

and as search string

='('&if(GetSelectedCount( Month )=0,month(today()),GetFieldSelections( Month,'|' ) )&')'

This will have always one or more values selected (if you clear the selection, the month of today is selected).

Re: ListBox - Always at least one Selected Value needed (not Always One Selected Value)

Wed, 01 Feb 2012 15:06:38 GMT

This is a great solution. Thanks for the help!

Re: ListBox - Always at least one Selected Value needed (not Always One Selected Value)

Anonymous — Fri, 13 Feb 2015 20:40:45 GMT

Nice Solution.

Re: ListBox - Always at least one Selected Value needed (not Always One Selected Value)

jessica_webb — Mon, 21 Dec 2015 14:20:19 GMT

Hi swuehl,

This is just what I'm looking for, but I'm struggling to apply it to my measures.

The field is called 'Location', and I would like it to default to 'London'.

So I'm trying:

='('&if(GetSelectedCount( Location)=0,'London'),GetFieldSelections( Location,'|' ) )&')'

But that doesn't seem to be right.

Are you able to advise?
Many thanks.

Re: ListBox - Always at least one Selected Value needed (not Always One Selected Value)

swuehl — Mon, 21 Dec 2015 17:31:57 GMT

Jessica,

I think you need to remove the closing bracket after 'London':

='('&if(GetSelectedCount( Location)=0,'London',GetFieldSelections( Location,'|' ) )&')'