restrict special character

[Anonymous]

how to restrict the special character in input box

[hallquist_nate]

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.

[Gysbert_Wassenaar]

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

[Anonymous]

it shows error in $ symbol

[Gysbert_Wassenaar]

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

[Anonymous]

no its not working

[Gysbert_Wassenaar · Accepted solution]

Works for me

[Anonymous]

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