Error Message to Display when something is selected out of Range

[#1]

Hi All,

My application has Year, Month and Quarter list box to select values. Lets say a user clicks on the Current Year and picks Q1 and accidentally chose December. I need to restrict this and display a message that the selection is incorrect. How can this be done?

What happens now is the application goes back to 2013 dec. But I lose other Key selections that drives the application.

Thanks,

[MK_QSL · Accepted solution]

If User has selected Q1, December would not be available for selection at all if you have proper data model...

Any way, you can have one trick...

All your list box, you can create by writing an expression

AGGR(Year,Year)

AGGR(Quarter, Quarter)

AGGR(Month,Month)

Try them and let us know if this will work for you or not...

[#3]

Hi,

In chart general tab Write a condition whatever you want and click on error message

and write user defined error message to provide to the user.

[#4]

Thank u Manish that works