Loading additional data on demand

marco_saku — Wed, 03 May 2017 13:23:28 GMT

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.

Re: Loading additional data on demand

vishsaggi — Wed, 03 May 2017 16:32:52 GMT

What is your datefield here?

May be try this?

LOAD *

FROM yoursource

WHERE

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

YoursourceDateField < MonthStart(Today()) ;

topic Re: Loading additional data on demand in QlikView

Loading additional data on demand

Re: Loading additional data on demand