topic Only get new data in Qlik NPrinting

Only get new data

Fri, 02 Dec 2016 12:34:00 GMT

Hi,

I have a QVW that I use for sending reports through nprinting. This QVD is scheduled to run every 5 min to catch new information.

Is it possible to in npritning send only the new information between the latest interval so to speak.

I don't know maybe I explain myself badly.

But if they get a file 09:00 with some information and new information comes in 12:05 they only want this new information not the info that was in the old file.

Re: Only get new data

avinashelite — Fri, 02 Dec 2016 12:46:35 GMT

Best way would be is to add a flag in Qlikview for the latest data and in NPritning apply the filter for latest flag so that you could have more flexibility.

Re: Only get new data

Fri, 02 Dec 2016 12:50:27 GMT

Sounds great how would Implement this flag?

Re: Only get new data

avinashelite — Fri, 02 Dec 2016 12:57:39 GMT

I don't have info about your data ..

If you have implemented incremental logic then based on the time stamp you can create this flag like

Let vLastReload= //your last reload time

then in the data table

LOAD *,

If(date/Time_field >vLastReload,1,0) as NPritign_Flag

;

Or if its on the key then you might be using to tables

Old_date:

LOAD

Key,

if(NPritign_Flag=1,0,0) as NPritign_Flag

...

from

History;

New:

LOAD

Key,

1 as NPritign_Flag

...

from

New

where exist(Key,Key);

hope you got the idea