topic Re: Forbid Filter multiple selection in QlikView

Forbid Filter multiple selection

mohamed_ahid — Wed, 02 Oct 2013 13:40:49 GMT

Hi everybody

Ho can i forbid multiple selection on a filter .

i'm using V9.

Thx

Re: Forbid Filter multiple selection

jagan — Wed, 02 Oct 2013 13:54:44 GMT

Hi,

Select a value in the Filter and then Go to Properties -> Select "Always One Selected Value" option.

Regards,

Jagan.

Re: Forbid Filter multiple selection

mohamed_ahid — Wed, 02 Oct 2013 13:57:15 GMT

thx Jagan,

but this not what i'm lookin for .

there is a difference between having an always one selected value and forbid multiple selection.

i think that will be done with triggers but i'm not sure.

Re: Forbid Filter multiple selection

jagan — Wed, 02 Oct 2013 14:06:36 GMT

Hi,

Chck this http://community.qlik.com/docs/DOC-3884

Go to Document Properties -> Triggers -> Field Event Triggers -> Select the Field -> On Select Edit Actions (Click button) -> Add -> Selection -> Select in Field -> Give Dimension Name (In Field) and in expression (=If(GetSelectedCount(Year), Max(Year)) ) in Search string.

Hope this helps you.

Regards,

Jagan.

Re: Forbid Filter multiple selection

mohamed_ahid — Wed, 02 Oct 2013 14:48:46 GMT

thanx Jagan

This will not work for me because i'm using char on the list . in the exemple it's a number .

but its very useful .i will post the final solution.

Re: Forbid Filter multiple selection

jagan — Wed, 02 Oct 2013 17:13:28 GMT

Hi,

Instead of Max() use MaxString().

Regards,

jagan.

Re: Forbid Filter multiple selection

mohamed_ahid — Thu, 03 Oct 2013 11:57:28 GMT

Thanks jagan it works .