topic Input box with Variable clearing all selections in QlikView

Input box with Variable clearing all selections

CVR — Sat, 16 Nov 2024 18:17:03 GMT

Hello Qlik Geeks,

I have a requirement to create an input box and exclude the values from selections in a field when user inputs values from a that field. I am using variable for this and also triggers(Variable Event Triggers) with Actions (1. Select in Field and 2. Select Excluded). Everything is working fine but I am having an issue when deleting the inputs manually and hitting the ENTER key. This action is clearing all selections for remaining fields which does not have Always one selected option checked. Can you help me?

Thanks,

CVR

Re: Input box with Variable clearing all selections

rubenmarin — Thu, 30 Jul 2020 18:23:16 GMT

Hi, after 'Select in Field' you can try adding a 'lock all' and 'unlock field' (for the field selecting the excluded values), then the select excluded action and for last an 'unlock all' action

Re: Input box with Variable clearing all selections

CVR — Thu, 30 Jul 2020 18:39:35 GMT

Thanks a lot for the quick response. It is working now and I am going to accept this as a solution. I have one more question regarding the same i,e How can we clear the input values from input boxes with the button ? I am using Button with Action as Clear Field which clears the field but the input values inside the Input Box remains same and I have to delete it manually.

Thanks,

CVR

Re: Input box with Variable clearing all selections

rubenmarin — Sat, 01 Aug 2020 10:11:31 GMT

Hi, values in putbox are store in variables, you can assing a value to a variable using the action external-> set variable. You have to do an action for each variable.

To empty the value just left empty the 'Value' text box: