Increment : Is this a correct syntax.

[renuka_sasikumar]

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;

[mdmukramali]

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.