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

[#2]

tried with list box but its not working

[tresB]

It should. Please share a small sample app. If you are worried about the data, you can always scramble(Settings->Document Properties->Scramble tab) the data and share a small sample (Select one year or such important dimension which substantially reduces data scope->File->Reduce Data-> Keep Possible Values, now your file is a relatively smaller one with dummy data, probably you can share).

[#4]

Hello Shweta,

Can you try this way:

Test:

LOAD * INLINE [

    Time_Val, Efc

    5/15/2013 12:00:00 AM, 10

    5/15/2013 12:15:00 AM, 20

    5/15/2013 12:30:00 AM, 40

    5/15/2013 12:45:00 AM, 30

    5/16/2013 12:00:00 AM, 10

    5/16/2013 12:15:00 AM, 20

    5/16/2013 12:30:00 AM, 40

    5/16/2013 12:45:00 AM, 50

];

Test1:

LOAD

Timestamp#(Time_Val,'DD/MM/YYYY hh:mm:ss TT') as Time_Val1, Efc

Resident Test;

drop table Test;

And then use a straight table with

=date(floor(timestamp#(Time_Val1,'MM/DD/YYYY hh:mm:ss TT')),'MM/DD/YYYY') as Dimension

and

=Avg(Efc) as expression.

Hope this helps.

Thanks,

ASINGH