Loading additional data on demand

[marco_saku]

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.

[vishsaggi]

What is your datefield here?

May be try this?

LOAD *

FROM yoursource

WHERE

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

YoursourceDateField < MonthStart(Today()) ;