topic Input Box Constrain in QlikView

Input Box Constrain

Thu, 29 May 2014 08:29:14 GMT

I have a challenge around input box.

I have constrain it using Isnum($) and $>0, however, I want to further prevent users from inputting --1 to -10. Basically prevent any negative number going into input box

Any idea will be much appreciated.

Thanks

Re: Input Box Constrain

tresB — Thu, 29 May 2014 08:34:21 GMT

$>0 condition does that itself. Isn't it ?

Re: Input Box Constrain

Thu, 29 May 2014 08:38:38 GMT

Hi tresesco,

Thanks for reply.

$>0 works for signle negative (-1) however it doesn't work for double negative, i.e. --1.

Re: Input Box Constrain

cfz — Thu, 29 May 2014 08:49:05 GMT

Hi James,

Sorry if I am missing something. What do tou mean for dubble negatives? --1 is the same as 1 isn't it? That is why it deoesn't work.

Regards

Carlos

Re: Input Box Constrain

tresB — Thu, 29 May 2014 09:12:00 GMT

--1 is actually being taken as text. So I guess you can try the standard constraints -'Positive Intergers'.