Message box to show when value is too high

[ivandrago]

Hi,

I have the attached document, when a user enters a value in the Input Box if the Value is Higher than the Val amount I want it to warn the user i.e. Message Box that the figure they entered is too high.

As when they currently enter a value that it is higher than is what is actually there it shows all the results and the users think that this is the full result set.

Thanks

[engishfaque]

Dear Ivan,

Please check this thread.

How I assign macro variable value into qlikview variable???

Kind regards,

Ishfaque Ahmed

[AbhijitBansode]

Go to Constraints tab in the properties of input box.

Choose 'Custom' under 'input constraints' and write expression below:

IsNum($) and $ >= minVal and $ <= maxVal

where minVal and maxVal are the min and max amounts. this constraint will also take care of entering numbers only.

Happy Qliking,

Abhijit

[engishfaque · Accepted solution]

Dear Ivan,

Here is the solution, for which you are looking for.

If need be, please let me know.

Kind regards,

Ishfaque Ahmed

[AbhijitBansode]

If possible, try to avoid macro in appliaction. they won't work in AJAX or WebView mode of your desktop.

Your requirement can also be addressed by merely setting some properties of Input Box.

Please find attached application with this.

this will take care of below:

1. Ensure number is greater than 10

2. Will popup error message if text is entered instaed of number

3. Will take care of any leading or trailing spaces in the input.

Thanks,

Abhijit