topic Re: Input Field - Is it possible to restrict the values in Input field in QlikView https://community.qlik.com/t5/QlikView/Input-Field-Is-it-possible-to-restrict-the-values-in-Input-field/m-p/447540#M167014 <HTML><HEAD></HEAD><BODY><P>No, input fields cannot be validated. Only the data type is checked. Restricting the input field to a set of values is not possible. </P><P></P><P>Input fields are not to be confused with input boxes. The value assigned to variables with input boxes can be restricted and validated on input.</P></BODY></HTML> Fri, 12 Apr 2013 18:25:50 GMT Gysbert_Wassenaar 2013-04-12T18:25:50Z Input Field - Is it possible to restrict the values in Input field https://community.qlik.com/t5/QlikView/Input-Field-Is-it-possible-to-restrict-the-values-in-Input-field/m-p/447536#M167010 <HTML><HEAD></HEAD><BODY><P>Hi All, Is it possible to restrict the values in Input field? Example : User can enter the "0" or "1" in the input field. Regards Sathish</P></BODY></HTML> Thu, 11 Apr 2013 20:49:34 GMT https://community.qlik.com/t5/QlikView/Input-Field-Is-it-possible-to-restrict-the-values-in-Input-field/m-p/447536#M167010 sathishkumar_go 2013-04-11T20:49:34Z Re: Input Field - Is it possible to restrict the values in Input field https://community.qlik.com/t5/QlikView/Input-Field-Is-it-possible-to-restrict-the-values-in-Input-field/m-p/447537#M167011 <HTML><HEAD></HEAD><BODY><P>Yes. Very much possible. Attached is the example for your reference. </P></BODY></HTML> Thu, 11 Apr 2013 21:38:22 GMT https://community.qlik.com/t5/QlikView/Input-Field-Is-it-possible-to-restrict-the-values-in-Input-field/m-p/447537#M167011 manojkvrajan 2013-04-11T21:38:22Z Re: Input Field - Is it possible to restrict the values in Input field https://community.qlik.com/t5/QlikView/Input-Field-Is-it-possible-to-restrict-the-values-in-Input-field/m-p/447538#M167012 <HTML><HEAD></HEAD><BODY><P>Manoj, Please try to understand my question. I want to restrict in "Input Field" not Input Box. Regards Sathish</P></BODY></HTML> Fri, 12 Apr 2013 16:49:26 GMT https://community.qlik.com/t5/QlikView/Input-Field-Is-it-possible-to-restrict-the-values-in-Input-field/m-p/447538#M167012 sathishkumar_go 2013-04-12T16:49:26Z Re: Input Field - Is it possible to restrict the values in Input field https://community.qlik.com/t5/QlikView/Input-Field-Is-it-possible-to-restrict-the-values-in-Input-field/m-p/447539#M167013 <HTML><HEAD></HEAD><BODY><P>Manoj, Please try to understand my question. I want to restrict in "Input Field" not Input Box. Regards Sathish</P><P>Manoj, Please try to understand my question. I want to restrict in "Input Field" not Input Box. Regards Sathish</P></BODY></HTML> Fri, 12 Apr 2013 16:50:10 GMT https://community.qlik.com/t5/QlikView/Input-Field-Is-it-possible-to-restrict-the-values-in-Input-field/m-p/447539#M167013 sathishkumar_go 2013-04-12T16:50:10Z Re: Input Field - Is it possible to restrict the values in Input field https://community.qlik.com/t5/QlikView/Input-Field-Is-it-possible-to-restrict-the-values-in-Input-field/m-p/447540#M167014 <HTML><HEAD></HEAD><BODY><P>No, input fields cannot be validated. Only the data type is checked. Restricting the input field to a set of values is not possible. </P><P></P><P>Input fields are not to be confused with input boxes. The value assigned to variables with input boxes can be restricted and validated on input.</P></BODY></HTML> Fri, 12 Apr 2013 18:25:50 GMT https://community.qlik.com/t5/QlikView/Input-Field-Is-it-possible-to-restrict-the-values-in-Input-field/m-p/447540#M167014 Gysbert_Wassenaar 2013-04-12T18:25:50Z Re: Input Field - Is it possible to restrict the values in Input field https://community.qlik.com/t5/QlikView/Input-Field-Is-it-possible-to-restrict-the-values-in-Input-field/m-p/447541#M167015 <HTML><HEAD></HEAD><BODY><P>I got it.. Gysbert is correct in regards with Input field validation</P></BODY></HTML> Fri, 12 Apr 2013 21:46:25 GMT https://community.qlik.com/t5/QlikView/Input-Field-Is-it-possible-to-restrict-the-values-in-Input-field/m-p/447541#M167015 manojkvrajan 2013-04-12T21:46:25Z Re: Input Field - Is it possible to restrict the values in Input field https://community.qlik.com/t5/QlikView/Input-Field-Is-it-possible-to-restrict-the-values-in-Input-field/m-p/447542#M167016 <HTML><HEAD></HEAD><BODY><P>You could try to at least alert the user to invalid input through highlighting.</P><P></P><P>If you load the input field in the script a second time to track the original value, then you can compare the current input value against the original value and highlight accordingly. You could also conditionally show a text box in a similar way.</P><P></P><P>if(FactType='Actual',Black(),if(avg(iASPGov15)&lt;&gt;avg(origASPGov15),lightRed(),lightBlue()))</P></BODY></HTML> Fri, 05 Jun 2015 06:26:17 GMT https://community.qlik.com/t5/QlikView/Input-Field-Is-it-possible-to-restrict-the-values-in-Input-field/m-p/447542#M167016 2015-06-05T06:26:17Z