Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
tried with list box but its not working
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).
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