Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Aria
Contributor III
Contributor III

QVD are not updated from incremental load

I create a QVD file from one application and load the data of one specific day(2021/05/23):

[inventory_v1]:
LOAD
"CALDAY",
"ZBASE_UOM___T",
"ZBASE_UOM",
"ZCUSTOMERNAM",
"ZSALESORDER";


SQL SELECT "CALDAY",
"ZBASE_UOM",
"ZBASE_UOM___T",
"ZCUSTOMERNAM",
"ZSALESORDER"
FROM "_SYS_BIC"."WLBI2.AL.MM/CVC_MM_STOCKAGE_SALES"
('PLACEHOLDER' = ('$$IN_QUERYDATE$$', '20210523'));
Store inventory_v1 into [lib://ibmQVD (qlik-pro_ibm.aria)/inventory_v1.qvd](qvd);

 

Then I create another application for conducting the incremental load into the inventory_v1.qvd:

let vDAY = Date(Today()-1,'YYYYMMDD');

[inventory_v2]:
LOAD
"CALDAY",
"ZBASE_UOM___T",
"ZBASE_UOM",
"ZCUSTOMERNAM",
"ZSALESORDER";


SQL SELECT "CALDAY",
"ZBASE_UOM",
"ZBASE_UOM___T",
"ZCUSTOMERNAM",
"ZSALESORDER"

FROM "_SYS_BIC"."WLBI2.AL.MM/CVC_MM_STOCKAGE_SALES"
('PLACEHOLDER' = ('$$IN_QUERYDATE$$', '$(vDAY)'));

Concatenate
Load * from [lib://ibmQVD (qlik-pro_ibm.aria)/inventory_v1.qvd](qvd) where CALDAY <> $(vDAY);

Store inventory_v2 into [lib://ibmQVD (qlik-pro_ibm.aria)/inventory_v1.qvd](qvd);

What I expecting is the data will be loaded into the QVD file on a daily basis and the QVD file should have the data of everyday starting from 2021/05/23.

Yet what I got is only the data of 2021/05/23 and the data of yesterday. For example: today is 5/27, the qvd file has the data of 5/23 and 5/26 without the data of 5/24 and 5/25

Why this happened? How can I fix this?

Thanks a lot !!

6 Replies
MayilVahanan

HI @Aria 

I create a QVD file from one application and load the data of one specific day(2021/05/23)

-- Are you loading this file daily?

 

Thanks & Regards,
Mayil Vahanan R
Aria
Contributor III
Contributor III
Author

Yes, through the variable: vDAY defined in the second application.

Aria
Contributor III
Contributor III
Author

Sorry my misunderstanding. No only the second application are loading on a daily basis. The first application has only been loaded once.

MayilVahanan

Its looks like script is fine .. If you have daily schedule, I think, its work fine. 

Or, you can debug the script once or check the log.

And also, Am not sure what this part will do.

('PLACEHOLDER' = ('$$IN_QUERYDATE$$', '$(vDAY)'));

Thanks & Regards,
Mayil Vahanan R
Aria
Contributor III
Contributor III
Author

where can I see the log please?

MayilVahanan

Hi @Aria 

in QMC-> Task->Status 

You can download from here

MayilVahanan_0-1622164295202.png

 

Thanks & Regards,
Mayil Vahanan R