Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna4bo
Creator
Creator

How to load data for two different situations.

Hi All,

How to load data for two different situations.

I am getting data Tuesday to Friday Daily basis, On Monday Weekly basis. How to implement incremental load for this type.

How to stop daily load on Saturday and load 3days dada on Monday dynamically.

A:

Select * From [lib://QVD/A.QVD]where Date>= Mothstart(Today()); // MTD

Concatinate

Load *

From Abc.Xlsx; // (Tuesday to Friday load )

Concatinate

Load *

From Abc.Xlsx where Date> =Date(Today-2);  //(Monday-Weekly file-filtered last 3 days)

Store A into [lib://QVD/A.QVD];

Thanks,

Krishna

0 Replies