topic Re: Can we set a variable or message for list boxes in QlikView

Can we set a variable or message for list boxes

kkkumar82 — Tue, 24 Mar 2015 06:58:54 GMT

Hi all,

I have a list of three list boxes lets say for SalesmanID, ProductID, DistributorID and my requirement is one should be able to select only any of these listboxes, if a list box is already selected with a value we should not be able to select another listbox or can we get a on screen message saying a list box is already selected or can we set a flag with value 1 or 0.

Thanks

Re: Can we set a variable or message for list boxes

awhitfield — Tue, 24 Mar 2015 10:16:31 GMT

Hi Kiran,

a simple way is to use a condition show on the layout tab of each of the three boxes,

e.g

add this to the SalesManID object

If(GetFieldSelections(ProductID)>0,0,If(GetFieldSelections(DistributorID)>0,0,1))

I have attached a simple example qvw

Andy

Re: Can we set a variable or message for list boxes

kkkumar82 — Tue, 24 Mar 2015 11:36:32 GMT

Hi Andrew,

Thanks for ur reply, the thing is I actually want to have all the list boxes shown but there should be only chance to select one list box only and if we try to select any other drop down a message should pop saying only one list box should be selected.

Thanks

Re: Can we set a variable or message for list boxes

awhitfield — Tue, 24 Mar 2015 14:42:17 GMT

HI Kiran, try the attached improved mark too version, you could make the Warning box conditional too!

Andy

Re: Can we set a variable or message for list boxes

kkkumar82 — Tue, 24 Mar 2015 14:51:13 GMT

Hi Andrew,

Can you let me know how list boxes are disabled when we select a list box value.

Thanks

Re: Can we set a variable or message for list boxes

awhitfield — Tue, 24 Mar 2015 15:01:26 GMT

Hi Kiran,

they are not actually disable, I've used a number of Semi Transparent Text box with a conditional show, which overlay part of the list boxes. if you user CTL+Shift+S to see the hidden text boxes!!

It's a bit of an optical illusion!

Andy

Re: Can we set a variable or message for list boxes

kkkumar82 — Tue, 24 Mar 2015 16:47:11 GMT

Thanks Andrew its really a good idea of hide and show mechanism.

** kiran Kumar **

Re: Can we set a variable or message for list boxes

awhitfield — Tue, 24 Mar 2015 16:50:03 GMT

you liked it!

Andy