Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can i veiw error message based on some condition

Hi Friends,

I need to show a error message based on a condition. I know it can be done by Custom Error message. But I don't know how to make a conditional statement.

Eg:

I have a date field if enter the wrong date means it show me pls enter the valid date....

1 Reply
Peter_Cammaert
Partner - Champion III
Partner - Champion III

This generic plan can help you in the creation of a solution:

  • Define what constitutes an iinvalid value (e.g. bounds? invalid month-day-year-values? etc.)
  • Translate these rules into a logical expression that checks whether a field is inside/outside these bounds
  • Add this expression to an IF() function that displays an error message in a text box whenever the conditions are met.

Note that QV does not have an IsDate() test function. But you can easily use date#() for that. If date#() returns NULL, then either the values ( e.g. '99/99/9999') or the format (e.g. '1/ABC/2015') of the parameter or both are wrong.

Peter