Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Load * from
//old qvd
Concatenate
Finance:
SQL SELECT * FROM XYZ
WHERE FLOOR([/LOAD_DT])>=(=max(FLOOR([/LOAD_DT])))
AND
REQUID >(=max(REQUID));
STORE Finance_Increment INTO D:\Qlikview Development\Finance Increment\Finance_Increment.qvd;
Dear ,
You need to Create two Variables which will store the
vMax_LOAD_DT = Max(/LOAD_DT)
and
vMax_REQUID = Max(REQUID)
from Old Qvd
and
then
Finance_Increment:
Load * from
//old Qvd
Concatenate
SQL SELECT * FROM XYZ
WHERE FLOOR([/LOAD_DT])>$(vMax_LOAD_DT)
and
REQUID >$(vMax_REQUID);
STORE Finance_Increment INTO D:\Qlikview Development\Finance Increment\Finance_Increment.qvd;
Thanks,
Mukram.