Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
adibaba08
New Contributor II

need help with group

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

3 Replies
jason_michaelid
Honored Contributor II

Re: need help with group

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
Valued Contributor III

Re: need help with group

The following new field seems to work:

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

jason_michaelid
Honored Contributor II

Re: need help with group

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

Community Browser