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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sudhir0538
Creator
Creator

Mailing using Alerts

Hello Community,

I have a data having flags 0's and 1's. After reloading the QVW (post reload) user needs to be alerted by an e-mail where it contains the no of devices are 0's and no of devices are 1's. Please help me how can i get the list of devices whose status is 0 and 1. Help also required in configuring mail part.

Main_Imgae.JPG

Here in the above image Name_Tuyer is machine id and Status is flag. I want a mail like this ,if suppose Tuyer 1 status is 1 and after reloading the status changed to '0' then a mail will trigger to user and states that the status has been changed for this tuyer. Likewise all other machines status also in a single mail.

2 Replies
Anonymous
Not applicable

that process is long, you need use vbscript for send mail.


https://community.qlik.com/docs/DOC-7851



sudhir0538
Creator
Creator
Author

Hi, Thanks ! That's okay I can use this VB Script. But how Can I  identify the status change after post reload? How can I compare the new status with the Old one??