Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Dear Ivan,
Here is the solution, for which you are looking for.
If need be, please let me know.
Kind regards,
Ishfaque Ahmed
Dear Ivan,
Please check this thread.
How I assign macro variable value into qlikview variable???
Kind regards,
Ishfaque Ahmed
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
Dear Ivan,
Here is the solution, for which you are looking for.
If need be, please let me know.
Kind regards,
Ishfaque Ahmed
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