Increment : Is this a correct syntax.

renuka_sasikumar — Mon, 28 Apr 2014 07:51:16 GMT

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;

Re: Increment : Is this a correct syntax.

mdmukramali — Mon, 28 Apr 2014 08:03:17 GMT

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.