topic Re: Incremental QVD Generation : Last Update Date issue. in QlikView

Incremental QVD Generation : Last Update Date issue.

infosense_devel — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

i am having scenario as per below an i don't know how to handle this scenario.

i have one view "XX_INCREMENTAL_DEMO", using this view i am generating QVD based on incremental Load.

my view have data as per below.

and i am using below syntax for incremental load.

CALL Qvc.IncrementalSetup ('XX_INCREMENTAL_DEMO', 'LAST_UPDATE_DATE', 'LINE_ID');

Directory;

[$(Qvc.Loader.v.Tablename)]:

LOAD *;

SQL SELECT *

FROM XX_INCREMENTAL_DEMO

WHERE $(Qvc.Loader.v.IncrementalExpression)

and unit_selling_price is not null ; //Because of this condition line_id 8 and 9 will not be part of this QVD.

so my QVD looks like below.

now after one or two days my view will have data for UNIT_SELLING_PRICE and it will not Update LAST_UPDATE_DATE.

after one or two days my view will be like below.

as you can see Last update date is not update incremental load is not considering this lines.

anyone have idea how to handle this kind of situation in Qlik?

Thanks in Advance.

Re: Incremental QVD Generation : Last Update Date issue.

Gysbert_Wassenaar — Wed, 22 Jun 2016 10:17:59 GMT

Tell your source database to stop telling you lies. The records were updated since, so the Last_update_date value should reflect that. Garbage in, garbage out. That's not something Qlikview can solve for you.

Re: Incremental QVD Generation : Last Update Date issue.

infosense_devel — Wed, 22 Jun 2016 10:46:42 GMT

Thanks for your reply gwassenaar‌.

in my scenario i am having VIEW and the column "Unit_selling_price" i am getting by executing function.

and Last_Update_date is coming from table. so for Unit_selling_price today function may not return value but tomorrow it will return value but Last_update_date in table will not updated.

that is the case for me. is there any way to handle this gwassenaar?