topic Re: Comapring old data and updated data and highlight the updates in QlikView https://community.qlik.com/t5/QlikView/Comapring-old-data-and-updated-data-and-highlight-the-updates/m-p/742003#M1032631 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>Any help on this?</P><P><A href="https://community.qlik.com/qlik-users/8752">jaganmohan</A> <A href="https://community.qlik.com/qlik-users/26418">tresesco</A></P><P></P><P>Regards</P><P>KC</P></BODY></HTML> Thu, 05 Feb 2015 10:01:25 GMT jyothish8807 2015-02-05T10:01:25Z Comapring old data and updated data and highlight the updates https://community.qlik.com/t5/QlikView/Comapring-old-data-and-updated-data-and-highlight-the-updates/m-p/742002#M1032630 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>I was trying to do something fancy and got stuck.</P><P>I am pulling data from few excel sheets and those sheets get updated from users on daily basis. They may add data or may update the old data or may delete data. So I used to consolidate all the data together into one sheet.</P><P></P><P>Is there any way by which I can detect the updates which was done by the user today from the data loaded at the time of previous load?</P><P>Any help on this will be really appreciated.</P><P></P><P>Thanks and Regards</P><P>Jyothish KC</P></BODY></HTML> Wed, 04 Feb 2015 10:37:31 GMT https://community.qlik.com/t5/QlikView/Comapring-old-data-and-updated-data-and-highlight-the-updates/m-p/742002#M1032630 jyothish8807 2015-02-04T10:37:31Z Re: Comapring old data and updated data and highlight the updates https://community.qlik.com/t5/QlikView/Comapring-old-data-and-updated-data-and-highlight-the-updates/m-p/742003#M1032631 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>Any help on this?</P><P><A href="https://community.qlik.com/qlik-users/8752">jaganmohan</A> <A href="https://community.qlik.com/qlik-users/26418">tresesco</A></P><P></P><P>Regards</P><P>KC</P></BODY></HTML> Thu, 05 Feb 2015 10:01:25 GMT https://community.qlik.com/t5/QlikView/Comapring-old-data-and-updated-data-and-highlight-the-updates/m-p/742003#M1032631 jyothish8807 2015-02-05T10:01:25Z Re: Comapring old data and updated data and highlight the updates https://community.qlik.com/t5/QlikView/Comapring-old-data-and-updated-data-and-highlight-the-updates/m-p/742004#M1032632 <HTML><HEAD></HEAD><BODY><P>Create qvd daily; compare yesterday's qvd data with the excel data to be loaded today. To do this there has to be a unique identifier of the record i.e. primary key. But here without the timestamp you might not be able to implement effective incremental load(which you possibly are not looking for).</P></BODY></HTML> Fri, 06 Feb 2015 05:25:15 GMT https://community.qlik.com/t5/QlikView/Comapring-old-data-and-updated-data-and-highlight-the-updates/m-p/742004#M1032632 tresB 2015-02-06T05:25:15Z Re: Comapring old data and updated data and highlight the updates https://community.qlik.com/t5/QlikView/Comapring-old-data-and-updated-data-and-highlight-the-updates/m-p/742005#M1032633 <HTML><HEAD></HEAD><BODY><P>Thanks a lot <A href="https://community.qlik.com/qlik-users/26418">tresesco</A> for the logic. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>l will try to implement this.</P><P></P><P>Regards</P><P>KC</P></BODY></HTML> Fri, 06 Feb 2015 05:31:08 GMT https://community.qlik.com/t5/QlikView/Comapring-old-data-and-updated-data-and-highlight-the-updates/m-p/742005#M1032633 jyothish8807 2015-02-06T05:31:08Z