topic Re: Re: Query in QlikView

Query

_rohitgharat — Wed, 03 Dec 2014 06:26:43 GMT

I have a query...

Suppose i have taken a fiscal year field in a list box. If i select more

than 2 selections on fiscal year its should be auto cleared..what logic can

i apply to this???

Re: Query

jagadeesh_diamo — Wed, 03 Dec 2014 06:28:22 GMT

Can you elaborate more?

Re: Query

_rohitgharat — Wed, 03 Dec 2014 06:33:19 GMT

For example:

Fiscal years (2011,2012,2013,2014,2015)

If i select 2012, 2013,2014 then selection should be auto cleared it should

allow only 2 selections at a time not more than that.

Re: Query

tresB — Wed, 03 Dec 2014 06:33:59 GMT

If you want users not to allow more than one value to select, you can check for 'Always One Selected Value' option. Select a value in the list box->General tab->enable 'always one selected value'.

Re: Query

_rohitgharat — Wed, 03 Dec 2014 10:32:08 GMT

Please reply if there is any solution..

Re: Re: Query

tresB — Wed, 03 Dec 2014 10:38:28 GMT

You can use trigger, like in sample qvw attached.

Clear field trigger:

=If(GetSelectedCount(YourField)>1, 'YourField')

Re: Query

maxgro — Wed, 03 Dec 2014 10:42:11 GMT

see attachment

there is a trigger in menù --> settings --> document properties