Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
marco_saku
Contributor
Contributor

Loading additional data on demand

Hi all,

I am new with QlikView. I would use it as Data Visualization tool in my company. I am working on the desktop version with our data stored in a data warehouse.

Does it exist any possibilty of loading first a part of data (stored in a table) and then, if needed, load more data? For instance, opening the document, I would like to load only the sales data of last month (since for the most part the analysis is done with this subset of data). Yet, if needed, I would query the dwh to get the data of older months.

For example setting the date from a calendar object.

Thanks all.

1 Reply
vishsaggi
Champion III
Champion III

What is your datefield here?

May be try this?

LOAD *

FROM yoursource

WHERE

YoursourceDateField >= MonthStart(MonthStart(Today() - 1)) AND

YoursourceDateField < MonthStart(Today()) ;