topic Re: how can I simulate the 'always one value selected'? in QlikView

how can I simulate the 'always one value selected'?

Mon, 29 Sep 2014 15:44:40 GMT

Hi Dear Experts,

I need simulate the option of 'Always one value selected' , if I said simulate is because, if I select that option can't clean in other tab

so somebody have any idea about how can simulate in a list box the same functionallity of 'Always one value selected' option?

Best regards.

Re: how can I simulate the 'always one value selected'?

bgerchikov — Mon, 29 Sep 2014 16:12:58 GMT

Hi Roldan,

There are several options to handle this problem:

Trigger on Tab open to assign certain value to the field while moving to selected Tab

Disregard field selection in Set Analysis (recommended):

Field1=

etc

Hope it will help

Re: how can I simulate the 'always one value selected'?

tcullinane — Mon, 29 Sep 2014 16:14:50 GMT

I'd say use sheet property triggers to define a variable as the selection, you can then use an input box with constraints to change the selection in the sheet rather than a list box and a clear trigger on leaving the sheet if need be. this will however result in the same variable always being selected on sheet open, it wont be persistent

Re: how can I simulate the 'always one value selected'?

Mon, 29 Sep 2014 16:25:01 GMT

Just like @boris Gerchikov said, several options, most easy is to create triggers on selected Tab, setAnalysis and third option by macro on selection (do not recommend this last one), but it might help if you want to save the previous selection before entering the Tab which activates the trigger... once you are done, when you return to the original Tab you may restore previous selection.

Cheers!

Re: how can I simulate the 'always one value selected'?

Wed, 01 Oct 2014 18:47:59 GMT

thanks Thomas ,

where I can configure the constraints of the imput box?.

you mean the variable set with the value of the selection?

best regards.

Re: how can I simulate the 'always one value selected'?

Wed, 01 Oct 2014 20:42:10 GMT

Hi Boris thanks for answer,

well I do the trigger on tab but when select other value the selection has two values and I need only one.

is any way to do that with out the configuration of 'Always one value selected'?

best regards.

Re: how can I simulate the 'always one value selected'?

Wed, 01 Oct 2014 20:43:54 GMT

the Set Analysis where a can configurate?.

regards.

Re: how can I simulate the 'always one value selected'?

Wed, 01 Oct 2014 21:01:16 GMT

Hi,

I tried with lock fields, please have a look at the appln attached.

Hope it helps.

Kiru

Re: how can I simulate the 'always one value selected'?

Wed, 01 Oct 2014 22:03:13 GMT

Hi Kiruthi, thanks a lot.

well is good the trigger but I mean,

in the first tab, the list box, have to change but, only with one value. and this not affect the second tab.

and with out the 'always one value selected'

best regards.

Re: how can I simulate the 'always one value selected'?

bgerchikov — Thu, 02 Oct 2014 15:09:45 GMT

Hi Roldan,

I think the Alternate State option would be a useful choice. Try it out.

Thanks!

Re: how can I simulate the 'always one value selected'?

Thu, 02 Oct 2014 15:16:49 GMT

Thanks Boris,

I tried but I have tri tabs and use variables in the tri and the alterenate states works fine but I have problems with the variables because the objects respet the estate but the variables not.

any Idea?

best regards.

Re: how can I simulate the 'always one value selected'?

bgerchikov — Thu, 02 Oct 2014 15:27:13 GMT

Roldan,

It's kind of difficult to help you using words only. We need to take a look on the App to understand what you're trying to do and give you a good advice. I'd suggest you to attach sample file.

Thanks!

Re: Re: how can I simulate the 'always one value selected'?

Thu, 02 Oct 2014 17:45:20 GMT

Boris I really appreciate yor answer.

in these attach example shows the way I do and for axample
I set a variable and it variable shwos a value in a table and in a list box thats fine but, ta value is not selected and thats where I need.

Any idea?

BEST REGARDS.