Below is the code trying to refresh, some part as monthwise based on if condition, Here If condition is satisfied then my code is working fine if not monthwise data is completely skipping.
what I am expecting is if month wise data IF condition is not satisfied then skip to next step, but already existing data(Month wise) should display. Just to avoid daily loading of Table1(Month wise data)
LET vEveryMonth = Num(MonthStart(today()));
If $(vEveryMonth) = Num(Today()) then
//Need to refresh once in a Month(start date of every month)
//Loading Month wise data Table1: Load * From Facttable.qvd(QVD)
WHERE DATE(floor(CalendarDate),'YYYYMMDD')<=date(floor(monthend(addmonths(Today(),-1))), 'YYYYMMDD');
//Loading Daily Data
Load * From Facttable.qvd(QVD)
Where DATE(floor(CalendarDate),'YYYYMMDD')>date(floor(monthend(Today(),-1)), 'YYYYMMDD
Here my intention using the same qvd is monthly summarising data from 1st qvd like the month should get completed from 1st qvd and if the month is current month it should show only daily data from 2nd.
Concatenation god both qvd’s will get result like below sample.
Like wise until the current month gets completed should show in date wise .
I have achieved the report as per the requirement but only one thing here is I need to avoid the daily reload of 1st qvd means month qvd.
That’s why looking for load once in a month of month qvd.
As my IF condition is working only date gets matched else completely skipping the month qvd and not showing month data in report