Row wise calculation

[#1]

Hi all,

I want to calculate the average of data based on time range. Like suppose i have 3 values each  for 3 days,then i want to calculate the average of values based on a particular day.

Data is already loaded in qlikview through excel.

Please help me with this.

Thanks

[tresB]

Is this what you want?

PFA

[#3]

hi tresesco

There is no attachment

[tresB]

It is there.

Still one more i am oploading, if it comes visible to you.

[#5]

No attachment. Can you please send it again?

[tresB]

Load this data,

Load * inline [
Date, Sales
06-09-2013, 100
06-09-2013, 200
06-09-2013, 300
06-09-2013, 400
07-09-2013, 300
07-09-2013, 400
07-09-2013, 500
];

Then Create a Straight table with Date as dimension, expression Avg(Sales). Check the result and let know.

[#7]

considering your example, I have already loaded both fields Date and Sales.

Now I want to avg out the values based on dates and which should be independent of selection.

So if I am using chart, how I am supposed to write expression ?

ex.select avg(Sales) from ..... where date="06-09-2013 something similar to this.

[tresB]

This?

Avg ({<Date={'06-09-2013'}>} Sales)

[#9]

PFA.

In this I have already loaded fileds 'Time_Val' & 'Efficiency' from my database.

Now I want another listbox which will have average values of efficiency based on date.

[tresB]

In the script something like:

Load Avg(Efficiency) as AvgEff

From <> Group By Date;

Or list box expression:

Aggr(Avg(Efficiency), Date)