Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 
infosense_devel
Creator II
Creator 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
Gysbert_Wassenaar

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
Creator II
Creator II
Author

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?