topic Email Alerts for Data in QlikView in QlikView https://community.qlik.com/t5/QlikView/Email-Alerts-for-Data-in-QlikView/m-p/91852#M457480 <HTML><HEAD></HEAD><BODY><P>I have a data which has Revenue generated by each user everyday. I want to set up an email alert when the revenue for Today is more than 20% less than yesterday's. I am not sure how to set it up. I was trying to use this formula. Sum({&lt;Order_Charged_Date={"$(=Date((Max(C), -1)))"}&gt;}Price_in_USD) for yesterday's revenue but not sure how to compare it with Today's revenue and send an alert.</P><P></P><P>Any help will be appreciated.</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 30 Oct 2018 18:04:32 GMT Anonymous 2018-10-30T18:04:32Z Email Alerts for Data in QlikView https://community.qlik.com/t5/QlikView/Email-Alerts-for-Data-in-QlikView/m-p/91852#M457480 <HTML><HEAD></HEAD><BODY><P>I have a data which has Revenue generated by each user everyday. I want to set up an email alert when the revenue for Today is more than 20% less than yesterday's. I am not sure how to set it up. I was trying to use this formula. Sum({&lt;Order_Charged_Date={"$(=Date((Max(C), -1)))"}&gt;}Price_in_USD) for yesterday's revenue but not sure how to compare it with Today's revenue and send an alert.</P><P></P><P>Any help will be appreciated.</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 30 Oct 2018 18:04:32 GMT https://community.qlik.com/t5/QlikView/Email-Alerts-for-Data-in-QlikView/m-p/91852#M457480 Anonymous 2018-10-30T18:04:32Z Re: Email Alerts for Data in QlikView https://community.qlik.com/t5/QlikView/Email-Alerts-for-Data-in-QlikView/m-p/1508585#M457481 <P>Try this condition:</P><PRE>1 - Sum({&lt;Order_Charged_Date={"$(=Date((Max(C))))"}&gt;}Price_in_USD) <BR />/ Sum({&lt;Order_Charged_Date={"$(=Date((Max(C), -1)))"}&gt;}Price_in_USD) &gt; 0.2</PRE> Sun, 18 Nov 2018 07:49:16 GMT https://community.qlik.com/t5/QlikView/Email-Alerts-for-Data-in-QlikView/m-p/1508585#M457481 Gysbert_Wassenaar 2018-11-18T07:49:16Z