Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
navaneeth79
Contributor II
Contributor II

Prediction

Hello all, a very warm morning

I have a data of average ram utilization for last 30 days say 4%, I want to predict the ram utilization at next 30th day or 60th day.

for example for oct if ram utilization is 4% at the end of month (total avg) we could be able to predict the ram utilization at say 30th November.

can anyone please help me out in this

1 Reply
micheledenardi
Specialist II
Specialist II

Ram utilization depends from lots of things like:

- Number of active users (concurrent);

- Dimension of your documents (in terms of number of record and dimensions);

- Load script quality and calculations;

- Hardware;

So if you want to predict the amount of RAM at 30th november and we assume:

- Number of concurrent active users at 30th nov is the same as today;

- The number of dimensions at 30th nov is the same as today;

- Load script quality and calculations at at 30th nov is the same as today;

- Hardware at 30th nov is the same as today;

- Records increase steadily;

- Your Layout doesn't change;


Assuming that PROBABLY your ram calculation prediction could be something like:

January RAM usage incr.= RAM at 31/01/2017 - RAM at 01/01/2017

February RAM usage incr.= RAM at 28/02/2017 - RAM at 01/02/2017

March RAM usage incr.= RAM at 31/03/2017 - RAM at 01/03/2017

April RAM usage incr.= RAM at 30/04/2017 - RAM at 01/04/2017

May RAM usage incr.= RAM at 31/05/2017 - RAM at 01/05/2017

June RAM usage incr.= RAM at 30/06/2017 - RAM at 01/06/2017

July RAM usage incr.= RAM at 31/07/2017 - RAM at 01/07/2017

August RAM usage incr.= RAM at 31/08/2017 - RAM at 01/08/2017

September RAM usage incr.= RAM at 30/09/2017 - RAM at 01/09/2017

October RAM usage incr.= RAM at 31/10/2017 - RAM at 01/10/2017

AVG Monthly RAM usage incr.= (January RAM usage incr. + February RAM usage incr. + March RAM usage incr. + April RAM usage incr. + May RAM usage incr. + June RAM usage incr. + July RAM usage incr. + August RAM usage incr. + September RAM usage incr. + October RAM usage incr.)/10

Ram needed at 30/11/2017= RAM at 31/10/2017 + AVG Monthly RAM usage incr.

Hope it helps

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.