Is that possible to Append/Add data to QlikView Application based on user request.

[#1]

Hi Guys,

I was trying to load only 6 months data into Memory initially because maximum users (80%) browse 6 months data but few staffs (20%) browse above 6 months data like 12 Months/18 months/24 months data weekly or monthly basis but not on daily basis.

The main purpose of doing this is to save RAM (Instead of loading 2 years data into ram load only 6 months and if someone wants then he/she should load 12/18/24 months data into memory but again on next day it will drooped from memory and will have 6 months data into memory ) space so that number of concurrent users may increase.

Initially I thought, I should make 4 documents each contains 6 month data and can provide 3 buttons like "Show 2nd 6 months data" ''Action:Open QlikView Document'' for 2nd 6 months/3rd 6 months/4th 6 months.

Main Application Recent 6 monthsjavascript:;
			2nd 6 Months Data Doc-2	3rd 6 Months Data Doc-3	4th 6 Months Data Doc-4

But this technique will not work if someone wants to aggregate 5th month and 7th month data because 5th month data will be available in 1st 6 month document (Doc-1) and 7th month data will be available in 2nd 6 month document (Doc-2) and both will be opening separately.

Then I thought ok lets go in this way:

Main Application (Doc-1) holds recent 6 months Data, Doc-2 Holds recent 12 months data, Doc-3 holds recent 18 months data, Doc-4 holds 24 months

Main Application Recent 6 months
			Recent 12 Months Data Doc-2	Recent 18 Months Data Doc-3	Recent 24 Months Data Doc-4

But here I will be loading repetitive data in Doc-2, Doc-3, Doc-4.

Next I thought, Is that possible that initially I should bring only 6 months data into memory and if someone request (Need to provide user control) then another 6/12/18 months data should bring into memory and should be appended with initial 6 months data.

Note: I don't want to give reload control to users.

Experts I need you guys help to fix and decide the best design.

[rwunderlich]

‌what I meant was not to create 4 documents of 6 months each. Rather 4 documents that contain

6 months

12 months

18 months

24 months

and let the user select the one they want.

is this really too big to just provide 24 months to everyone? How much RAM does 24 months require?

[#3]

Hi Rob,

We have 2 Servers and each having 512 GB RAM. 2 applications are very big having 2 years of data (600 Millions) each application. Having 15 concurrent user license.  If I load 2 years data for one application it is using 60 GB RAM on server. If I load 6 months data It is using only 20 GB RAM on Server.

Now suggest what would be best practise to achieve this?

[#4]

Hi Sunny,

I am facing some issue.

Need your help to Automate this script to Reload data based on user request

On Initial run It is loading 12 months data but expectation was it should load 6 months. The reason for it is variable vFile value is 12 default.

[rwunderlich]

‌i would just make 2 documents. One 6 months, one 24 months. You have plenty of RAM on the server. Further, I would use Document Analyzer or another tool to optimize the RAM footprint of the document.