topic Re: Message box to show when value is too high in QlikView

Message box to show when value is too high

ivandrago — Tue, 26 Aug 2014 22:21:48 GMT

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

Re: Message box to show when value is too high

engishfaque — Wed, 27 Aug 2014 05:33:29 GMT

Dear Ivan,

Please check this thread.

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

Kind regards,

Ishfaque Ahmed

Re: Message box to show when value is too high

AbhijitBansode — Wed, 27 Aug 2014 05:42:48 GMT

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

Re: Message box to show when value is too high

engishfaque — Wed, 27 Aug 2014 07:04:08 GMT

Dear Ivan,

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

If need be, please let me know.

Kind regards,

Ishfaque Ahmed

Re: Message box to show when value is too high

AbhijitBansode — Thu, 28 Aug 2014 06:46:25 GMT

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