Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Not applicable

Only get new data

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.

3 Replies

Re: Only get new data

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.

Not applicable

Re: Only get new data

Sounds great how would Implement this flag?

Re: Only get new data

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

Community Browser