Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
saivina2920
Creator
Creator

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

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.

Field has blank.PNG

Field has blank - Gujarat.PNG

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')

 

Labels (1)
34 Replies
QFabian
Specialist III
Specialist III

QFabian_0-1611078260177.png

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

QFabian_1-1611078318456.png

 

QFabian
saivina2920
Creator
Creator
Author

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
Creator
Creator
Author

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
Creator
Creator
Author

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
Creator
Creator
Author

any update...

saivina2920
Creator
Creator
Author

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
Master
Master

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
Creator
Creator
Author

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
Master
Master

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:

edwin_0-1612362140444.png

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
Creator
Creator
Author

can you give us the sample file...?