topic Compare with Old Data in QlikView https://community.qlik.com/t5/QlikView/Compare-with-Old-Data/m-p/44095#M784869 <HTML><HEAD></HEAD><BODY><P>Hello Community,</P><P>I have a table where there's a flag field , contains ON / OFF data. After reloading the data is replacing and the data is not storing in database(historical).</P><P>How can I make a comparison for the flag field. i.e before reloading say it's ON and after reload it's OFF. I want to know the status change of the flag and based on that i need to design an alert.</P><P></P><P>Please help. Sample data attached!</P><P></P><P>Message was edited by: Sudhir Kumar</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT sudhir0538 2020-11-25T16:16:04Z Compare with Old Data https://community.qlik.com/t5/QlikView/Compare-with-Old-Data/m-p/44095#M784869 <HTML><HEAD></HEAD><BODY><P>Hello Community,</P><P>I have a table where there's a flag field , contains ON / OFF data. After reloading the data is replacing and the data is not storing in database(historical).</P><P>How can I make a comparison for the flag field. i.e before reloading say it's ON and after reload it's OFF. I want to know the status change of the flag and based on that i need to design an alert.</P><P></P><P>Please help. Sample data attached!</P><P></P><P>Message was edited by: Sudhir Kumar</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Compare-with-Old-Data/m-p/44095#M784869 sudhir0538 2020-11-25T16:16:04Z Re: Compare with Old Data https://community.qlik.com/t5/QlikView/Compare-with-Old-Data/m-p/44096#M784870 <HTML><HEAD></HEAD><BODY><P>Do you want to check what was the flag of the data before loading as it is changed after reload?</P></BODY></HTML> Sat, 17 Mar 2018 08:50:19 GMT https://community.qlik.com/t5/QlikView/Compare-with-Old-Data/m-p/44096#M784870 shiveshsingh 2018-03-17T08:50:19Z Re: Compare with Old Data https://community.qlik.com/t5/QlikView/Compare-with-Old-Data/m-p/44097#M784871 <HTML><HEAD></HEAD><BODY><P>Yes , If it's state changed from ON to OFF or vice versa I need to generate an alert mailing.</P></BODY></HTML> Sat, 17 Mar 2018 08:53:06 GMT https://community.qlik.com/t5/QlikView/Compare-with-Old-Data/m-p/44097#M784871 sudhir0538 2018-03-17T08:53:06Z Re: Compare with Old Data https://community.qlik.com/t5/QlikView/Compare-with-Old-Data/m-p/44098#M784872 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>If my understanding is correct then u can use incremental load option here.</P><P></P><P></P><P><A href="https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/" title="https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/">https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/</A></P></BODY></HTML> Sat, 17 Mar 2018 09:25:02 GMT https://community.qlik.com/t5/QlikView/Compare-with-Old-Data/m-p/44098#M784872 tripatirao 2018-03-17T09:25:02Z Re: Compare with Old Data https://community.qlik.com/t5/QlikView/Compare-with-Old-Data/m-p/44099#M784873 <HTML><HEAD></HEAD><BODY><P>hi tripati,</P><P>Can u explain me in details !! As I'm new and unable to do !</P></BODY></HTML> Sat, 17 Mar 2018 13:05:20 GMT https://community.qlik.com/t5/QlikView/Compare-with-Old-Data/m-p/44099#M784873 sudhir0538 2018-03-17T13:05:20Z Re: Compare with Old Data https://community.qlik.com/t5/QlikView/Compare-with-Old-Data/m-p/44100#M784874 <HTML><HEAD></HEAD><BODY><P>Load previous data in other table and compare after reload</P></BODY></HTML> Mon, 19 Mar 2018 16:13:41 GMT https://community.qlik.com/t5/QlikView/Compare-with-Old-Data/m-p/44100#M784874 shiveshsingh 2018-03-19T16:13:41Z