Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Sounds great how would Implement this flag?
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