topic Week by week comparison. in QlikView https://community.qlik.com/t5/QlikView/Week-by-week-comparison/m-p/473833#M176993 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a requirement like i have the data in spread sheet which i download from the website(on any day) and manually i have to add the filed " download date".</P><P></P><P>So the data fields are like download date,sr no,logged date, entry#, total amout etcc...</P><P></P><P>The requirement is the data which we have to download from the website is change at any time.Here we have to compare the data between the first time downloaded spread sheet and next time downloaded spread sheet as a weekly basis.</P><P></P><P>Eg: download date&nbsp;&nbsp; sr no&nbsp;&nbsp;&nbsp;&nbsp; logged date&nbsp;&nbsp;&nbsp; entry#&nbsp;&nbsp;&nbsp; total amount</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04/07/13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 101&nbsp;&nbsp;&nbsp;&nbsp; 28/06/13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100098&nbsp;&nbsp;&nbsp; 600000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; total records we have is 1001</P><P></P><P>2nd downloaded spread sheet</P><P></P><TABLE><TBODY><TR><TD>download date&nbsp;&nbsp; sr no </TD><TD>logged date</TD><TD>entry#</TD><TD>total amount</TD></TR><TR><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/07/13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TD><TD>101 </TD><TD>28/06/13&nbsp;&nbsp;&nbsp; </TD><TD>100098</TD><TD> 600000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TD><TD>total records we have is 1020</TD></TR></TBODY></TABLE><P>&nbsp; </P><P>Note : the thing is columns are same in both the times but only rows will change.We have to compare the changes week by week.</P><P></P><P>Let me know if in case of any concerns in this regard.</P><P></P><P>Thanks in advance,</P><P>Ravi Teja</P></BODY></HTML> Fri, 12 Jul 2013 07:10:27 GMT 2013-07-12T07:10:27Z Week by week comparison. https://community.qlik.com/t5/QlikView/Week-by-week-comparison/m-p/473833#M176993 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a requirement like i have the data in spread sheet which i download from the website(on any day) and manually i have to add the filed " download date".</P><P></P><P>So the data fields are like download date,sr no,logged date, entry#, total amout etcc...</P><P></P><P>The requirement is the data which we have to download from the website is change at any time.Here we have to compare the data between the first time downloaded spread sheet and next time downloaded spread sheet as a weekly basis.</P><P></P><P>Eg: download date&nbsp;&nbsp; sr no&nbsp;&nbsp;&nbsp;&nbsp; logged date&nbsp;&nbsp;&nbsp; entry#&nbsp;&nbsp;&nbsp; total amount</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04/07/13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 101&nbsp;&nbsp;&nbsp;&nbsp; 28/06/13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100098&nbsp;&nbsp;&nbsp; 600000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; total records we have is 1001</P><P></P><P>2nd downloaded spread sheet</P><P></P><TABLE><TBODY><TR><TD>download date&nbsp;&nbsp; sr no </TD><TD>logged date</TD><TD>entry#</TD><TD>total amount</TD></TR><TR><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/07/13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TD><TD>101 </TD><TD>28/06/13&nbsp;&nbsp;&nbsp; </TD><TD>100098</TD><TD> 600000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TD><TD>total records we have is 1020</TD></TR></TBODY></TABLE><P>&nbsp; </P><P>Note : the thing is columns are same in both the times but only rows will change.We have to compare the changes week by week.</P><P></P><P>Let me know if in case of any concerns in this regard.</P><P></P><P>Thanks in advance,</P><P>Ravi Teja</P></BODY></HTML> Fri, 12 Jul 2013 07:10:27 GMT https://community.qlik.com/t5/QlikView/Week-by-week-comparison/m-p/473833#M176993 2013-07-12T07:10:27Z Re: Week by week comparison. https://community.qlik.com/t5/QlikView/Week-by-week-comparison/m-p/473834#M176994 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>small correction alignment in spread 2.</P><P></P><P>download date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sr no&nbsp;&nbsp;&nbsp; logged date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; entry#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; total amount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>01/07/13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 101&nbsp;&nbsp;&nbsp; 28/06/13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10098&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 600000</P></BODY></HTML> Fri, 12 Jul 2013 07:15:53 GMT https://community.qlik.com/t5/QlikView/Week-by-week-comparison/m-p/473834#M176994 2013-07-12T07:15:53Z