topic Re: need help with group in QlikView

need help with group

Anonymous — Sat, 21 Jul 2012 13:55:30 GMT

Hi all

Need your help.

my data looks like this :

date chlid child download

14/7/12 14:00 a 123

14/7/12 14:00 b 166

14/7/12 14:15 a 173

14/7/12 14:15 b 176

14/7/12 14:30 a 153

14/7/12 14:30 b 156

14/7/12 14:45 a 143

14/7/12 14:45 b 146

14/7/12 15:00 a 123

14/7/12 15:00 b 166

14/7/12 15:15 a 173

14/7/12 15:15 b 176

14/7/12 15:30 a 153

14/7/12 15:30 b 156

14/7/12 15:45 a 143

14/7/12 15:45 b 146

i need to know the avg download per HOUR for each child

for example

14/7/12 14:00 a 148

14/7/12 14:00 b 161

thx

Jason_Michaelides — Sat, 21 Jul 2012 14:13:26 GMT

I'd probably create a new field in the script:

TimeStamp(Floor(date) + (1/24*Hour(Date))) AS DateHourStart

Then, use this and child as the dimensions in your chart, with Avg([child download]) as the expression.

Hope this helps,

Jason

nagaiank — Sat, 21 Jul 2012 14:24:40 GMT

The following new field seems to work:

Text(Date(Timestamp#(date,'DD/M/YY hh:mm'),'DD/MM/YYYY hh')) as DateHr

Jason_Michaelides — Sat, 21 Jul 2012 17:29:23 GMT

Although I think you'd lose the numeric quality with your solution, krishnamoorthy. Might be useful...