topic validation error message in QlikView

validation error message

jagannalla — Tue, 25 Oct 2011 07:35:16 GMT

Hi,

- The above image is inputbox with two variables.

Now my task is like this,

If i enter in vLB with value which is less than 15 i should get error message " please enter the value above 15" and also if the value of vLB is greather than the vUB value then the error message should be "Please enter the value less than vUB" and vice versa for vUB.

Re: validation error message

RSvebeck — Tue, 25 Oct 2011 07:48:53 GMT

You can create a variable trigger which calls a macro where you can have any vailidation you like.

Like this macro (in my example, the variable name is "vTest"):

sub Validate_vTest
set v = ActiveDocument.Variables("vTest")
getVariable = v.GetContent.String
if v.GetContent.String > 5 then msgbox "Value is to high!"
end sub

// Robert Svebeck

validation error message

jagannalla — Tue, 25 Oct 2011 09:09:50 GMT

Hi,

But this will not work out at access point. Is there any other way to achive this?

Re: validation error message

sbaldwin — Tue, 25 Oct 2011 10:57:54 GMT

Hi, you could do something with hidden text boxes like the attached.

Thanks

Steve

Re: validation error message

Tue, 25 Oct 2011 11:05:34 GMT

Jagan,

Check out the attachment. It can be done thru inputbox constraints.

validation error message

jagannalla — Thu, 27 Oct 2011 10:16:30 GMT

Kiran,

It's working fine..But if you give vInput1 greather than vInput2 it shows the erro msg "Should be greater than15" instead of "Should be less than vInput2". Can you please check once.

Re: validation error message

Thu, 27 Oct 2011 10:27:05 GMT

Yes, its not working. I am not sure if this a bug. Alternativly you can put the error message as:

Should be greater than 15 and less than vInput2

Kiran

Re: validation error message

jagannalla — Thu, 27 Oct 2011 10:34:36 GMT

Right know my application is working like what you said. But, i'm trying to change the way of this.