Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
What is your datefield here?
May be try this?
LOAD *
FROM yoursource
WHERE
YoursourceDateField >= MonthStart(MonthStart(Today() - 1)) AND
YoursourceDateField < MonthStart(Today()) ;