Need to load only 6 months data in memory and another 6-6-6 months should be loaded on click

[#1]

Hi Guys,

I have 2 years of data into DWH and shame need to report into dashboard. But in general, maximum number of users see latest 6 months data (1st 6 months data) and very few see rest.

Need to design a dashboard which should load only current 6 months data in memory and another 6 Months, 6 Months and 6 months should be loaded on click (Based on user request). I think this mechanism is called document chaining.

I think for above scenario, I should have 4 documents 1st document should hold 1st 6 months data, 2nd document should hold 2nd 6 months data, 3rd document should hold 3rd 6 months data and 4th document should hold 4th 6 months data.

Always 1st 6 months data should be loaded into memory and should be published. If users click on tab  "2nd 6 Months Data" then 2nd 6 months data should be bring into memory and same way for others tabs.

I tried searching any example QVW which is designed using document chaining but did not get it. If any one has done this could you please share steps how to do it or having any sample qvw, please share it.

[maxgro]

all documents must be published

for each document you can choose to preload a document (in memory) or load the document in memory when the first user will open the document

document chaining just means you can open another doc from a Qlik doc and transfer the selection

http://community.qlik.com/message/657811#657811