topic Re: Input field range restrictions to user in QlikView

Input field range restrictions to user

Thu, 21 Mar 2013 12:09:46 GMT

Hi All,

I have one input filed and it has the integer values in that. Values is range of 800 to 2700. That Inputfield I can enter any number now. Here I need to restrict to the user to enter only the value with in the range of 800-2700. How can I restrict ? Can you please help us?

Thank you

Srikanth Kota

Re: Input field range restrictions to user

Gysbert_Wassenaar — Thu, 21 Mar 2013 12:19:31 GMT

It's not possible to restrict the values in an inputfield. Anything that is valid for the data type of the field can be entered.

Re: Input field range restrictions to user

Thu, 21 Mar 2013 12:46:46 GMT

Hi Manideep,

That is input field not input box, where I am taking that in Listbox. User is going to enter the range of values as I said.

Thank you

Srikanth Kota

Re: Input field range restrictions to user

Thu, 21 Mar 2013 12:53:51 GMT

Hi,

Is there anything preventing you from building those values in the script (from 800 to 2700) and then just displaying them in the list box? User could scroll for the number they want or search for it

-art

Re: Input field range restrictions to user

Thu, 21 Mar 2013 13:15:56 GMT

Hi,

Try using below expression in you list

if(Values>=800 and Values<=2700,Values)

Re: Input field range restrictions to user

Thu, 21 Mar 2013 13:29:57 GMT

Hi Swetha,

I already given a try with that expression. If we use that we are going to loose the Input field functionality.

Thank you

Srikanth Kota

Re: Input field range restrictions to user

Thu, 21 Mar 2013 13:32:42 GMT

Hi Atatum,

Initial load we are taking the range of values from excel. Later if we want that user can enter any number like input with in the range. by the we are not able to restrict other than range.

Thank you

Srikanth Kota

Re: Input field range restrictions to user

er_mohit — Thu, 21 Mar 2013 13:36:19 GMT

try this

rangeonly(if(fieldname>=800 and fieldname<=2700,fielname))as newfieldname