Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a listbox with windows checkbox as style.
so based on other listbox, this listbox is populated. so there are some excluded values, that are shown when those values are not related.
so i tried hiding it, but it shows gray space in that place, so i want to disable those excluded values.
user shouldnt be able to select those excluded values.
can we do that?
Hi,
Instead of hiding and disabling use Aggr(FieldName,FieldName) for that listbox as expression which show you only possible values.
Celambarasan
Hi Celambarasan,
Thanks for reply,
its working but have problem in that. All values will be selected by default.
if i unselect (uncheck) some values from that, even those values are getting hided.
that shouldnt happen.
And one more problem i have in this,
am using select in field action in activate sheet, when i come to that sheet.
in select in field, am giving product_name as field and '*' as value.
but if i use expression in that, then i cant use select in field action for that field in activate sheet now right?
Aggr(product_name,product_name)
Hi Udaya:
Try the attached App - hope this helps...
Thanks,
Narasimha K
To summarize for anyone trying to reproduce this - the key here is ticking the option "Always One Selectied Value" in Listbox1 thus selection in Listbox2 will behave as desired.
This is a nice trick, but unfortunately not universal.
QV really lacks an option "Disable selection of excluded values".
Maybe it will be doable via macros.
Simply mesmerizing!!!!!
I would advice against hiding the gray values - simply because they show important information that the user may not have realized. When you hide them, you assume that the user already has made the correct selection and so, you show the answer to this question.
But in real life, the user often does not know the question. Instead, he needs to click-and-try to see what happens. And in this process, the gray values are an important help to the user to "navigate to the right question".
HIC
IMO - this is pretty much dependent on personal preference and use-case scenario. In case of digging in unknown data, your suggestion might be preferrable, but in case you have a stable dataset, hiding values might be the lesser of the two evils.
Of course - if QV implemented the most reasonable behavior "disable selection of excluded values" - we wouldnt not have to do the compromise.
Unfortunately it seems QV is focusing on other areas and QV desktop looks quite abandoned, so i do not keep much hope of any improvement.