topic Re: Always one selected value in a expression based multibox in QlikView

Always one selected value in a expression based multibox

Thu, 30 Jul 2015 06:30:47 GMT

I have a expression based field to be displayed in multibox. I am not able to find/choose 'Always one selected value' or 'Override Locked Field' in the presentation tab under fields. Only option available to click and choose is -Closed Multi Box-, but not the expression.

So is there any way to achieve always one selected value ???

Thanks in advance

Re: Always one selected value in a expression based multibox

MK_QSL — Thu, 30 Jul 2015 06:36:13 GMT

It's on presentation tab... lower right side... You need to select at least one value and then the field name to enable that option

Re: Always one selected value in a expression based multibox

Anonymous — Thu, 30 Jul 2015 06:49:55 GMT

you can only use the available fields to define "always one selected"

as soon as you enter an Expression you cannot even select the Expression under presentation

try to put your Expression into script and use the new field in multibox

Re: Always one selected value in a expression based multibox

SatyaPaleti — Thu, 30 Jul 2015 07:05:16 GMT

Hi Anusha,

To use 'Always one selected value' or 'Override Locked Field' in the presentation tab under fields. U need to follow some steps.

1. If I am having a fields called City. (City has Hyderabad,Mumbai,Calcutta,Nagpur,Bangalore etc..) State(State has AP,KAR,TN,MH,WB etc..) you want to select only one value In City field then

1st create Multibox that should have City field. select any one city from the field for example Hyderabad, Once you select then go to properties --> Presentation --> It will show you fields (City & State) select city --> it will show Always one selected value' or 'Override Locked Field'. check both boxes then hit OK.

Now you can select only one field from City. if you want to select only one field from State. do the same process

Hope you Understand

Thank you,

Satya Paleti