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

Thanks for all your help.

We were working java script at many applications. we addict for that.

that's why we are expecting the same.

Anyhow we can show to user at least this text object concept.

One last question, Is it possible to hide the textbox till user selects the dropdown by default...?

otherwise i accept your solution. Thanks once again..

edwin
Master
Master

you are saying not to show the text box unless there is at least one selection?  you can add that to the condition:

=GetSelectedCount(EMP_STATE)>0 and Count(EMP_STATE)>Count(EMP_RELIEVE_DATE)

saivina2920
Creator
Creator
Author

Yes. Awesome. 

Thanks for all your help..

edwin
Master
Master

yw

_sabkamalikek
Contributor
Contributor

hi @saivina2920 , were you able to send alert to people when the field is blank? my use case is somewhat same. where we need to send people fields name if it is blank using qliksense