Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
infosense_devel
Contributor II

Incremental QVD Generation : Last Update Date issue.

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.

first.png

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.

second.png

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.

third.png

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.


2 Replies
MVP & Luminary
MVP & Luminary

Re: Incremental QVD Generation : Last Update Date issue.

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.


talk is cheap, supply exceeds demand
infosense_devel
Contributor II

Re: Incremental QVD Generation : Last Update Date issue.

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?