topic Re: Input box in QlikView

Input box

Wed, 09 Feb 2011 09:02:33 GMT

Hi,

Using the custom option in the input box . We can check the input box value against the constraint set.

Is it possible to restrict the user to enter only the specific format in the input box . Like only the date format can be entered in the input box?

Input box

suniljain — Wed, 09 Feb 2011 09:05:43 GMT

to restrict user to enter only valid value. you have to use macro.

Input box

Miguel_Angel_Baeyens — Wed, 09 Feb 2011 09:42:21 GMT

Hello,

You can set a custom rule, for example

=Index($, '/') > 1 and Index($, '.') > 1

So the variable will accept "3/3.3" or "A.B/C" but not "10000"

You can customize it to your needs and date format.

Hope that helps.

Input box

Wed, 09 Feb 2011 13:11:05 GMT

Thanks Sunil and Miguel,

I have used the below macro for to check the same. It is checking whether it is in date format or not. but not able to define as dd/mm/yyyy or mm/dd/yyyy.

Sub Checkformat
Set v = ActiveDocument.Variables("Date")
value=v.getcontent.String
result= (IsDate(Value))
Msgbox(result)
Msgbox(value)
End sub

Any suggestions on the same.

Re: Input box

Sat, 04 Jun 2011 11:55:04 GMT

One my colleagues just sent me this so I cannot take credit..... I believe this is what you were looking for (no macro).

Contrain your input box with the following:

len(date(date#($))) > 0 AND date#($) < date#(vEndDate)

Provide an Error message:

='Invalid Date. Use format: ' & (DateFormat) & ' and Start Date must be less than End Date'