topic Re: InputField input constrains in QlikView

InputField input constrains

Thu, 13 Feb 2014 11:23:13 GMT

Hi team,

Is there any chance to have input constrains for the values of an inputfield? e.g. If I have an inputfield that I want to get filled only with numeric values (i also want to have something like illegal sound or error message if the user try to insert text or any other invalid value).

Regards,

Eleni

Re: InputField input constrains

Nicole-Smith — Thu, 13 Feb 2014 13:51:37 GMT

Yes, in input box properties:

You can find more info on the constraints in QV help:

Re: InputField input constrains

simondachstr — Thu, 13 Feb 2014 14:07:29 GMT

InputSum(InputField) - this prohibits the user entering anything else than a numeric value.

Re: InputField input constrains

Fri, 14 Feb 2014 14:14:44 GMT

Hi Nicole,

Thank you for your reply but I am talking about input fields and not Input box.

Regards,

Eleni

Re: InputField input constrains

Fri, 14 Feb 2014 14:16:00 GMT

Hi Martin,

Thank you for your reply, but what happens if you want text or date format for your inputfield?

Kind Regards,

Eleni

Re: InputField input constrains

rbecher — Fri, 14 Feb 2014 14:28:51 GMT

Then use two separate input fields..

Re: InputField input constrains

Fri, 14 Feb 2014 14:59:24 GMT

In which way?

Could you please give me more info or a sample?

Kind Regards,

Helen

Re: InputField input constrains

rbecher — Sun, 16 Feb 2014 15:46:19 GMT

I meant I wouldn't mix different formats in one input field. So I would use one field for text input and another for date input..

Re: InputField input constrains

Mon, 17 Feb 2014 08:18:50 GMT

Hi Ralf,

Sorry for the misunderstanding I don't want to have mixed formats in one input field, I just want an inputfield with input constrain date, I just want in some way to prevent that the user will type anything else in that field.

Re: Re: InputField input constrains

rbecher — Mon, 17 Feb 2014 10:12:37 GMT

Hi Eleni,

you could have a custom input constraint like this:

IsNum(Date#($, 'DD.MM.YYYY'))

But I would suggest to use a calendar object to intput/select a date. Then also you have the date value as a number in the variable which is better for use with set analysis.

- Ralf

Re: Re: InputField input constrains

Mon, 17 Feb 2014 10:32:03 GMT

Hi Ralf,

The whole problem is that we want an Inputfield and not a variable. We want the user to see an inputfield in a list box or a table box and fill it with date values. I want to find a way to prohibit any other value than date format value to get input in this field.

Eleni

Re: InputField input constrains

rbecher — Mon, 17 Feb 2014 10:56:29 GMT

Ah, I see. I think this is not possible..