Is that possible to Append/Add data to QlikView Application based on user request.
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.
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.
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.
You won't get duplicate rows. But you may get other problems such as file collisions. I don't think you really want users reloading - esp different data -- in the server environment. Everyone shares the same copy. So if someone reloads to add another 12 months, everyone sees the extra 12 months. Then if another user asks for an additional 6 months, the 12 months is overlayed and the first user is unhappy.
I would recommend creating 2 documents. The recent 6 months, which 80% use. It has a button to "see all data" that opens the 24 month doc.
So your RAM overlap is for 6 months. How much RAM is that?
I wasn't recommending a reload on the access point itself. I don't even know if that is possible or not. What we are doing is that allowing users with developer license download a copy of the application from the server and perform a partial reload to compare new data against the old one. I understand the concern that letting a reload on the server would create version control issue, but a downloaded copy will be user specific and won't have that issue.
1. You create separate QVDs for each 6 month segment. Then have a variable in a drop down that lets the user select how may months they want. Reference the variable in the load to load the proper QVDs.
2. Binary load can only load one QVW. If the machine has enough RAM to Binary load the entire dataset, you can load Binary load the 24 month copy and use an INNER JOIN to delete the unwanted months.
I am trying for this only. Even I am trying to Popup a message if any user has already loaded data.
LET vNow=Now();
LOAD_ON_REQUEST_CONFIG:
LOAD * INLINE [
RunDateTime, NumberOfMonths, LoadFlag
$(vNow), 12, 0
$(vNow), 18, 0
$(vNow), 24, 0
];
STORE LOAD_ON_REQUEST_CONFIG INTO $(vQVDsFolderPath)\LOAD_ON_REQUEST_CONFIG.QVD;
DROP TABLE LOAD_ON_REQUEST_CONFIG;
If any user has loaded the data It will be updating the flag to 1 and so next time if some one trying to reload it will check the flag in table if it is already 1 then display a message that data has been reloaded by other user and it is available to all.
I tried this but problem is that when users want to see 5th month data and 7th month data (in one document), in that case 5th month data resides in 1st 6 month document and 7th month data resides in 2nd 6 months document.
So I am looking for the ways to combining all 4 documents data into one and show if required.
If you say it is possible could you please elaborate it.
Based on your logic, I am trying to do Binary load from a 24 month QVW files based on a variable 12 months, 18 months, 24 months.
So I will have a QVW which holds 24 months data. In my application, I will use this qvw file to do binary load and show only 6 months data default and when users want to see 12 months or 18 months or 24 months, he/she should select a variable and the click on reload (Full Load) and then It will load 12 month or 18 months or 24 months based on variable selection and I will have QVD file which holds RunDateTime,NumberOfMonths,LoadFlag
LET vNow=Now();
LOAD_ON_REQUES_CONFIG:
LOAD * INLINE [
RunDateTime, NumberOfMonths, LoadFlag
$(vNow), 12, 0
$(vNow), 18, 0
$(vNow), 24, 0
];
Initially LoadFlag will be 0 and if any users reloaded data on that day it will set to 1 so that when next user try to reload data It will pop a message that data is already reloaded by other user and available for all.
