topic Re: Lock/Unlock a field depending on selections in another field in QlikView

Lock/Unlock a field depending on selections in another field

ashish_2511 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community

I've two fields in list boxes - Product and Region.

My requirement is to force users to select a product prior to selecting a region.

For this I guess I've to lock the field region when there is no selections in product and then unlock it as soon as selection(s) is made on Product and repeat.

Please advise a way to achieve this.

*** I don't want to show/hide Region based on selection in Product.

*** I don't want to Hide the Region field with a text object.

Thanks! in advance

-Sneh

Re: Lock/Unlock a field depending on selections in another field

YoussefBelloum — Fri, 16 Mar 2018 09:28:58 GMT

Hi,

1 solution comes to my mind:

Create a conditional display on the second listbox like: Getselectedcount(field1)<>0 //this will show the second listbox only if you make selection on the first one.

Also, create a textbox to show message like: SELECT A VALUE ON FIRST LISTBOX with conditional display like: Getselectedcount(field1)=0 //this will show this textbox only if you don't select a value on the first listbox

Or anoher solution would be to write this expression on the second listbox: =if(GetSelectedCount(field1)<>0,field2)

Re: Lock/Unlock a field depending on selections in another field

nagaiank — Fri, 16 Mar 2018 09:45:16 GMT

A sample solution is attached.

Re: Lock/Unlock a field depending on selections in another field

shiveshsingh — Fri, 16 Mar 2018 09:49:50 GMT

I guess, you have attached the wrong QVW

Re: Lock/Unlock a field depending on selections in another field

shiveshsingh — Fri, 16 Mar 2018 09:52:43 GMT

I think, he doesn't want this solution, no hiding of object

Re: Lock/Unlock a field depending on selections in another field

ashish_2511 — Fri, 16 Mar 2018 10:05:56 GMT

Thanks for the reply.

I've already tried this. My client doesn't want this.

Re: Lock/Unlock a field depending on selections in another field

jyothish8807 — Fri, 16 Mar 2018 10:07:30 GMT

Try this app:

I have used two list box for region. One in read only state.

Br,

Re: Lock/Unlock a field depending on selections in another field

YoussefBelloum — Fri, 16 Mar 2018 10:09:26 GMT

nice one !

Re: Lock/Unlock a field depending on selections in another field

ashish_2511 — Fri, 16 Mar 2018 10:10:01 GMT

Just a dummy dataset, no UI stuff.

but others Could use this dataset to provide their solutions.

Re: Lock/Unlock a field depending on selections in another field

ashish_2511 — Fri, 16 Mar 2018 10:12:36 GMT

thanks for your reply.

I've also reached till this point but could you do some miracle to clear off the Region selection when product is cleared?

Re: Lock/Unlock a field depending on selections in another field

jyothish8807 — Fri, 16 Mar 2018 10:14:16 GMT

It will clear, since i am not locking any fileds. I just forcing the user to select a product prior to Region

Re: Lock/Unlock a field depending on selections in another field

PrashantSangle — Fri, 16 Mar 2018 10:19:58 GMT

Try below

1: create list box with expression as

aggr(product,product)

2: List box with product

go to property > general > hide excluded

This way you will show only data from Product which related to selected region only

Regards,

Re: Lock/Unlock a field depending on selections in another field

ashish_2511 — Fri, 16 Mar 2018 10:34:13 GMT

This fulfills just part of my requirement.

when you select a product and then a region and then deselect product, the selection in Region stays (both list boxes Read-only checked or unchecked)

Re: Lock/Unlock a field depending on selections in another field

ashish_2511 — Fri, 16 Mar 2018 10:40:05 GMT

Thanks! but this this doesn't serve my purpose.

As I've mentioned above -

when you select a product and then a region and then deselect product, the selection in Region stays

Re: Lock/Unlock a field depending on selections in another field

jyothish8807 — Fri, 16 Mar 2018 10:46:42 GMT

Try this

I have added on trigger

Re: Lock/Unlock a field depending on selections in another field

jyothish8807 — Fri, 16 Mar 2018 10:57:48 GMT

Did this worked ?

Re: Lock/Unlock a field depending on selections in another field

ashish_2511 — Fri, 16 Mar 2018 11:16:37 GMT

Yes this worked Thanks!

I'd totally disregarded the on any select trigger. I was just trying to make it work with field event triggers.

Re: Lock/Unlock a field depending on selections in another field

jyothish8807 — Fri, 16 Mar 2018 11:45:31 GMT

Happy to hear it worked

Have a great weekend.