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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Week by week comparison.

Hi All,

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".

So the data fields are like download date,sr no,logged date, entry#, total amout etcc...

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.

Eg: download date   sr no     logged date    entry#    total amount

      04/07/13              101     28/06/13        100098    600000                                   total records we have is 1001

2nd downloaded spread sheet

download date   sr no logged dateentry#total amount
      01/07/13          101 28/06/13    100098 600000                               total records we have is 1020

 

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.

Let me know if in case of any concerns in this regard.

Thanks in advance,

Ravi Teja

1 Reply
Not applicable
Author

Hi

small correction alignment in spread 2.

download date                         sr no    logged date                entry#                     total amount      

01/07/13                                   101    28/06/13                   10098                           600000