Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Siddhant1
Contributor

comparison between today's date with last day's data

I have requirement like count(S)= 1000 for today 

or count(s)= 985 for last day so i have to calculate the  difference between them like when data load yesterday count of s is 985 and when data load today the count of s is 1000 so difference is  15 

and i only have s field in my data no date's and other fields present in my data 

Labels (3)
3 Replies
Digvijay_Singh

May be you would store last day's count in a variable and every day check the variable value and the today's value to compare it. Store the latest value back to variable.  Hope you know how to do that using qlik scripting.

 

SunilChauhan
Champion II

generate two Qvd using 


Let vTOday=Date(TOday(),'DD-MM-YYYY');
Store TableName into lib://Test/TableName_$(vTOday).Qvd;

i.e load it TOday then load again on TOmmorow

now you have two Qvd

TableName_26-08-2022.Qvd

TableName_27-08-2022.Qvd

not  laod From QVd and show in Bar chart.

See the attached file

Sunil Chauhan
oskartoivonen
Partner - Contributor III

If I understood correctly, you have a field that is changing value day by day and you need to calculate the difference, but you're only receiving the latest value from the data? This means we must store the previous data in QVD format and reference that QVD for the difference calculation. You can add a new row into the QVD each day, or just whenever it changes, whichever is more convenient for you.