topic Re: comparison between today's date with last day's data in App Development

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

Siddhant1 — Tue, 23 Aug 2022 11:57:40 GMT

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

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

Digvijay_Singh — Thu, 25 Aug 2022 04:16:30 GMT

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.

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

SunilChauhan — Fri, 26 Aug 2022 06:58:34 GMT

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

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

oskartoivonen — Fri, 02 Sep 2022 14:58:25 GMT

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.