topic Re: listbox should be blocked except one data in QlikView

listbox should be blocked except one data

jagannalla — Fri, 02 Sep 2011 10:01:29 GMT

Hi,

I've two listboxes. When i select first listbox the other listbox should be blocked except one data.

For eg:

first listbox look like this:

First:

second listbox look like this:

Second:

- Now when i select any one in the first listbox the second listbox should be blocked except Y.

How can i overcome this can anyone help me..

listbox should be blocked except one data

Fri, 02 Sep 2011 10:13:27 GMT

Hi,

What if user don't see the excluded values in second list box

if that is ok with you then go to Properties -> General in second list box and check hide excluded.

User can not see the excluded values in second and also can not select from excluded.

HTH

Re: listbox should be blocked except one data

swuehl — Fri, 02 Sep 2011 11:07:26 GMT

Not the full solution, but I tried with document triggers like in attached file. Still having some limitations, but you may want to have a look.

I also tried with a calculated expression in a listbox, but got some strange behaviour, nothing I want to share yet..

Regards,

Stefan

listbox should be blocked except one data

jagannalla — Fri, 02 Sep 2011 12:09:37 GMT

Swuehl,

Thanks for your help..But when i unselect first lisbox and trying to select 2nd listbox with all contents it is not selecting. How can i select all contents in 2nd listbox. Now your application allows to select only one in the second listbox if i remove Hide excluded.

Can you help me on this little bit.

Re: listbox should be blocked except one data

swuehl — Fri, 02 Sep 2011 12:32:39 GMT

Please try attached

I replaced the search string in the trigger with

=if(GetSelectedCount(ListA),'Y', '('&replace(GetFieldSelections(ListB),', ','|')&')')

Regards,

Stefan

listbox should be blocked except one data

jagannalla — Fri, 02 Sep 2011 13:24:34 GMT

In application also it is not working...

Uncheck Hide exclude and try to select all contents of listB.

But i got solution..

Steps:

1. I checked Show alternative for first listbox.

2. I had taken two buttons to select and deselect the second listbox.

3. In first button i written actions like:

SelectExcluded ---> FieldName

SelectinField ---->FieldName and value as Y

LockField -----> FieldName

4. In second button i written actions like:

UnlockField ----> FieldName

Macrocode -----> To clear the fieldname

Re: listbox should be blocked except one data

swuehl — Fri, 02 Sep 2011 13:32:07 GMT

Well, If I deselect ListA values, I am able to select one, two or all values from ListB.

(tested with QV 10 SR2, with above attached application).

I can do this with option "Hide excluded" checked or unchecked.

But good if you have a working solution.

Edit:

Do you have any links between these two fields?

edited by swuehl