topic Selecting zero or only one option in a field in QlikView

Selecting zero or only one option in a field

thomastc — Mon, 02 Apr 2012 11:07:48 GMT

Not sure if this is possible.

I have a field with 3 possible values.

I want the users to be able to select either only one field or no fields.

I do not want a user to be able to select, at any time, 2 of the 3 options.

Select 1 of the 3 or none of the 3 (or all 3 as that is the same as none) only.

Additionally I cannot use macros.

Thanks!

Jason_Michaelides — Mon, 02 Apr 2012 11:14:55 GMT

I think you may have to use a trigger for this that counts the number of selections in a field and fires an action to go back if more than one.

Or else you could have a text box with a conditional show on it that blocks off all but your field and instructs the user to only select one value.

Hope this helps,

Jason

CELAMBARASAN — Mon, 02 Apr 2012 11:35:24 GMT

Hi,

Document properties-->Triggers-->under field event triggers select the field and add action for the on select use select in field

Specify the field name of the same and search string as =if(GetSelectedCount(FieldName)>=1,MinString(FieldName))

Celambarasan

jagan — Mon, 02 Apr 2012 11:42:30 GMT

Hi,

Hope the attached file helps you.

Regards,

Jagan.