topic Re: Single Selct List Box in QlikView

Single Selct List Box

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Greetings.

I have one list box called Market. I want to make it single selection.

I made it by :

But in this way , user cant clear this field. It is becoming mandatory.

User want this should be optional as well as Single Select.

Could you please help me how to do this.

Thanks,

Sarif

Re: Single Selct List Box

Chanty4u — Thu, 22 Mar 2018 10:24:00 GMT

try with document trigger with

onopen/onselect along wth on change clear field

Re: Single Selct List Box

Gysbert_Wassenaar — Thu, 22 Mar 2018 10:27:23 GMT

That's not possible. It can be both optional and Always One Selected Values. Always actually does mean always.

If you want you can add some black magick and add a Select in Field trigger with an action that clears the field if more than one value is selected. You can use the GetSelectedCount() function to check the number of selected values.

Re: Single Selct List Box

mhmmd_srf — Thu, 22 Mar 2018 10:32:43 GMT

in that way also it is becoming multi select.

I want to restrict this to single select.

Re: Single Selct List Box

Peter_Cammaert — Thu, 22 Mar 2018 10:34:11 GMT

It would be more useful if you can describe what selection behavior you want to support in this listbox.

Remember that clearing a field often means "Select Everything" (even though values go all white instead of green) which is the exact opposite of "Select exactly one".

Re: Single Selct List Box

mhmmd_srf — Thu, 22 Mar 2018 11:00:34 GMT

Hi ,

I am using below expression, but it is not working.

=if(GetSelectedCount(Market)>0,0,1)

Re: Single Selct List Box

Gysbert_Wassenaar — Thu, 22 Mar 2018 11:17:08 GMT

Your expression returns 1 or 0. Unless you have a field named 1 or 0 in your data model nothing will happen. Make your expression return a field name instead: =if(GetSelectedCount(Market)>0,'Market')

Re: Single Selct List Box

mhmmd_srf — Thu, 22 Mar 2018 13:03:16 GMT

hi Gysbert,

I have one question,

In the expression why we need to put Market as Text? I tried with field, it is not working though.

Just want to clarify my concept.

Thanks,

Sarif

Re: Single Selct List Box

Gysbert_Wassenaar — Thu, 22 Mar 2018 13:53:04 GMT

If you put the field in instead of as text it will try to get a value from the field instead of using the field name