how to create a monthly snapshot Data

dunnalahk123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have one QVD which will refresh on daily basis. based on that i have to count Projects on daily basis..

for example :

in my report i am showing data from 201611.

So from 201611 to latest month 201806 of till date i have 150 Projects

so when i report them in my report i have to show the 150 projects in june month

once i enter to july 1st again it should count from 201611 to july 31st and show number in july month.

once i enter to Aug 1st again it should count from 201611 to Aug 31st and show number in August month.

basically i need to take snapshot from 201611 to till date to publish the number to according month once month is completed.

from 201611 to june ending how many projects i have to count and show it in june month

from 201611 to july ending how many projects i have to count and show in July month.

Best Regards,

topic how to create a monthly snapshot Data in QlikView