topic How to disable multi-select in list box in QlikView

How to disable multi-select in list box

Thu, 02 Feb 2012 13:55:13 GMT

Hi all, I am greener of qlikview, Currently facing a problem as subject, I can't find a solution to disable multi-select in list box. We all kown that we can tick the option 'Always one selected value' in the list box property, tab 'General'. But it also bring side effort that make us can't implement unselect operation.

Does any one know how to only disable multi-select in a simple way? Really thx!

How to disable multi-select in list box

jagan — Thu, 02 Feb 2012 13:56:46 GMT

Hi,

Select a single option and check properties, Now this option is enable.

Regards,

jagan.

Re: How to disable multi-select in list box

ekech_infomotio — Thu, 02 Feb 2012 14:09:23 GMT

Hi Paul,

is it right that you sometimes want "Always one selected value" and sometimes not?

AFAIK it is only possible via macro - you will need two subroutines:

sub set_singlevalue

'please notice that you have to select a value before the option can be set

activedocument.fields("yourfieldname").select "yourdefaultvalue"

set fYOURFIELDNAME = activedocument.getfield("yourfieldname")

set prop = fYOURFIELDNAME.getproperties

prop.OneAndOnlyOne = true

fYOURFIELDNAME.SetProperties prop

end sub

sub set_multivalue

set fYOURFIELDNAME = activedocument.getfield("yourfieldname")

set prop = fYOURFIELDNAME.getproperties

prop.OneAndOnlyOne = false

fYOURFIELDNAME.SetProperties prop

end sub

then create two buttons (or text-objects) and set "EXTERNAL" ==> "Run Macro" as Action - one with set_multivalue and one with set_singlevalue.

please notice that you have to select a value before

regards,

Edgar

Re: How to disable multi-select in list box

Thu, 02 Feb 2012 14:17:31 GMT

thx for reply, but problem is that option is only for 'always select one value', which can't fullfill the requirement the situation of select none of them. Now my biz requirement is as below:

1.can select one value

2.can select none of the value

3.can't select multi-value

Do you know how to implement it?

Re: How to disable multi-select in list box

Thu, 02 Feb 2012 14:23:29 GMT

THX edgar, seem this micro still can't fix the problem o. maybe I didnt descript well.

This problem is: I can't select multi velue like below snapshot

========

A(selected)

B(selected)

C(un-select)

========

But i need impletement below 2 kinds of situations.

=========

A(selected)

B(un-select)

C(un-select)

=========

and

=========

A(un-select)

B(un-select)

C(un-select)

=========

Re: How to disable multi-select in list box

kuba_michalik — Thu, 02 Feb 2012 14:32:08 GMT

You don't really need a macro.

Set up a trigger for a field on an OnSelect event (Settings -> Document Properties -> Triggers). For field FIELD set up Selection -> Select in Field -> use =Only(FIELD) as Search String. Now if somebody selects one value, it gets selected, if somebody selects more than one - all get deselected immediately after.

EDIT: I'm including a quick example

Re: How to disable multi-select in list box

Thu, 02 Feb 2012 14:54:20 GMT

Really thx Kuba. It works perfect:)

Re: How to disable multi-select in list box

ekech_infomotio — Thu, 02 Feb 2012 14:57:11 GMT

cool. didn't know until now 😉