insert a column with the "inputavg" where I use this column as input parameter for calculation of another column. Example:
Column1 * inputavg = Total.
What I'm noticing is that after such change my application is taking too long to open and before that he consumed approximately 2.5 GB and now is consuming 6GB of memory.
Verify inputavg is part the of the data model and not on a island table. QlikView will try to calculate all the values of one column with all the values of other column if they are not related.
Also, I assume inputavg is defined as a inputfield, correct? If so, what you have to realize is that with the inputfield the size of the QlikView file and memory use can raise drastically. I assume this is because QlikView cannot do its column-based compression of duplicate data when it the data can change in QlikView.
The best practice is to limit the use of the inputfield to what the user really is going to change. For example, even if you have 5 years of information in QlikView, the user just needs to be able to play with 2 years of information in the what-if.
