How to throw alert message to user if the field is blank in qlikview

[saivina2920]

I have some data is blank. If the data is blank for the particular criteria, then it should throw alert message to user, "this filed has some blank"

example has shown below.

when user select EMP_STATE, then if find any blank available in the EMP_RELIEVE_DATE then, it should throw alert message to user "EMP_RELIEVE_DATE has some blank values"

below is my expressions. but, alert not showing...?

=if(IsNull(EMP_RELIEVE_DATE) AND [EMP_STATE]='$(vEmPlaces)','Contains Blank','Not blank')

[QFabian]

it is working, i just adjusted the expression , because you dont need to put the if , just the comparison

[saivina2920]

This is great. But, the alert will fire only once. why..?

whenever i am changing the EMP_STATE, it should automatically fire the alert based on the conditions.

????

[saivina2920]

can anyone tell us the update.

 the alert will fire only once i.e while loading the dashboard first time. why..?

whenever i am changing the EMP_STATE list box value, it should automatically fire the alert based on the blank data conditions.

????

[saivina2920]

can anyone help us to proceed further this activity..?

whenever i am changing the EMP_STATE list box value, it should automatically fire the alert based on the blank data conditions.

[saivina2920]

any update...

[saivina2920]

anyone can update pls. i am waiting for long time. no one has responded..

"whenever i am changing the EMP_STATE list box value, it should automatically fire the alert based on the blank data conditions."

[edwin]

instead of an alert, why not create a TEXT object in teh center of the screen.  if your condition is not met, show it otherwise hide it.  you can add an action to it that clears a specific field so that the conditions dont apply anymore, the text box disappears and the user can make new selections

[saivina2920]

my client specifically asking for alert. because in this case, alert doing major role.

i am not sure how TEXT Object will react in the dashboard.

Can i have some examples, how to create a TEXT object in the center of the screen...?

[edwin]

I think business requirements and system requirements are different.  alert in business terms should not be a literal translation,  if there is a graphic in the center of the screen like this:

the business may not care if it is an actual ALERT or it is a TEXT BOX, if the user experience is the same.  you can create a visual exactly like this and force the user to click on it to continue.  if you want to design the solution around alerts you may have to live with its limitations. 

[saivina2920]

can you give us the sample file...?