topic Re: How to refresh Part of code monthly in QlikView

How to refresh Part of code monthly

brucemazynzolt — Fri, 02 Nov 2018 15:42:24 GMT

Hi Experts,

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');

Concatenate

ENDIF;

//Loading Daily Data

Table2:

Load * From Facttable.qvd(QVD)

Where DATE(floor(CalendarDate),'YYYYMMDD')>date(floor(monthend(Today(),-1)), 'YYYYMMDD

Thanks In Advance,

Bruce Mazyn Zolt - BMZ

Re: How to refresh Part of code monthly

prieper — Fri, 02 Nov 2018 16:43:34 GMT

Why do you need the vEveryMonth?

Condition may also work with

IF TODAY() = MONTHSTART(TODAY()) ...

If would prefer to have the WHERE-clauses not on strings, but on numbers.

WHERE FLOOR(CalendarDate) < MONTHSTART(TODAY())

should do as well?

The CONCATENATE in this position is not clear to me, Loading with * from the same table will automatically concatenate.

What do you wish to achieve with the second condition?

Re: How to refresh Part of code monthly

brucemazynzolt — Mon, 05 Nov 2018 19:11:00 GMT

Hi Pete,

Thanks for your reply.

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.

Date. Sales

Aug-2018 10000

Sep-2018 20000

Oct-2018 30000

11-01-2018. 210

11-02-2018. 400

11-03-2018. 320

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