topic Average per Day in load in QlikView

Average per Day in load

Tue, 28 Apr 2009 20:35:03 GMT

Hi, everybody.

I have a following table:

Date Computer Calculations

2009/04/25 A 40

2009/04/25 B 10

2009/04/28 A 70

2009/04/29 B 90

and I need to build a resident table from this one in Load script

with this derivative data:

Date Computer AvgCalculationsPerDay

2009/04/25 A 10

2009/04/26 A 10

2009/04/27 A 10

2009/04/28 A 10

2009/04/25 B 30

2009/04/26 B 30

2009/04/27 B 30

2009/04/28 B 30

2009/04/29 B 30

Help please

Average per Day in load

disqr_rm — Tue, 28 Apr 2009 21:50:10 GMT

Hi,

The example of your data and the scenario do not make sense. Could you please elaborate little more?

Average per Day in load

Wed, 29 Apr 2009 14:38:17 GMT

Some explanation about the means of column Calculations:

The example with Computer A: On 2009/04/25 the value of calculations column is 40, there are some accumulations on 26,27 and the value in Calculations column is increased with 30 and the new value is 70 on 2009/04/28.

It's the same situation with computer B.

I need to calculate the average value per each day from 2009/04/25 to 2009/04/29 for each one computer (computer A and computer B)

Average per Day in load

Wed, 29 Apr 2009 16:10:29 GMT

Hi,

I`m not sure, whether i have understood your problem correctcly r not.

if my understanding was correct, attached application would help you to fill the missing rows.

If this helps you, all credits goes to Mr. Rob Since i had taken this application from his cookbook.

Good Luck

Regards

Sridhar