
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
