topic Re: restrict special character in QlikView

restrict special character

Anonymous — Mon, 18 Feb 2013 18:21:10 GMT

how to restrict the special character in input box

Re: restrict special character

hallquist_nate — Mon, 18 Feb 2013 20:25:32 GMT

If you go to the Help menu in QlikView and Search "Input Constraints", you'll find a search result called "Input Box Properties: Constraints" That will tell you everything you need to know. Basically, use Custom Contraints and dictate what is allowed to be entered.

Re: restrict special character

Gysbert_Wassenaar — Tue, 19 Feb 2013 12:26:33 GMT

If you want a constraint that only allows letters and numbers you can use this:

=len(PurgeChar($,'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789'))=0

If you want to allow more characters you can add them in the expression. Alternatively you could use something like this:

=len(KeepChar($,'`~@#$%^&*()_-+={[}]|\:;<>,./?'))=0

Re: restrict special character

Anonymous — Tue, 19 Feb 2013 17:06:50 GMT

it shows error in $ symbol

Re: restrict special character

Gysbert_Wassenaar — Tue, 19 Feb 2013 17:15:13 GMT

That's a bug in the expression editor. The $ will be substituted with the input value. Just try it.

Re: restrict special character

Anonymous — Tue, 19 Feb 2013 17:21:21 GMT

no its not working

Re: restrict special character

Gysbert_Wassenaar — Tue, 19 Feb 2013 17:53:00 GMT

Works for me

Re: restrict special character

Anonymous — Tue, 19 Feb 2013 18:03:25 GMT

ya thanks... its works... but i restrict the character without typing(when i press @ ,@ is not entering in the input box..)

now it s entering when press another object then only its validating