i have 3yrs (2011,2012,2013)of data in the application while doing the incremental load 1 more year (2014)data is added now the performance is reduced so any options to increase the performance. if i do the same function (adding 1yr (2015)more)again data will increase performance will reduce any suggestions.
Don't reload full. Try to reload Partial Reload using ADD prefix for now.. Also, You can think Incremental Load concept to load only recent data with Club into old data
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
in application . we have created the incremental load and actions performed in qmc on every month data is increasing and old data is also existed in the qlik memory so now the performance is reduced
Either this is from QMC not the Qlikview. Recently, One of my colleague faced the issue.
My side, The issue is Every reload happens the File size (QVW) got increased. Does this same your question? And this happened for me in QMC. Will it so?
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
As you have mentioned you have the problem in dashboard, instead of reloading.
specially you have an issue with qlikView consuming more memory.
in that case, follow the below steps:
you cannot skip any year of data, so skip the unwanted columns in data model.
identify the dimensions and facts to create a schema, so that you can easily eliminate duplicates.
check for synthetic keys specially.
if you have tried these things, but you need to keep that big data model in your memory, all you can do is taking care of your expressions and limit the values in chart
