Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to aggregate data hours,minutes,second wise in qlikview

Hi Community,

I have below test data

Time          Id

7.20.10       1

7.20.11        2

7.20.15        1

7.21.10        3

7.21.11        4

7.21.12        1

7.22.10         5

7.22.11        6

7.22.13        7

7.23.11        8

7.23.12        9

7.23.13       10

I want below expected output

Time        Id

7.20         4

7.21         8

7.22         18

7.23         27


How to achieve sum of the id on aggregated time field?


I have try below expression but it not worked


sum(aggr(sum(ID),Time))


Thanks in advance.

1 Solution

Accepted Solutions
sunny_talwar

Attaching an image and a sample

Capture.PNG

View solution in original post

5 Replies
Not applicable
Author

Can you provide sample data sheet so that it will be more useful. The question is not quite clear.

Anonymous
Not applicable
Author

Hi Community,

Any idea how to write expression for above problem?

It's argent

sunny_talwar

I this time field (7.20.10)? If it is then try to create a new field in the script like this

LOAD TimeField,

           Time(Floor(TimeField, 1/1440), 'h.mm') as FlooredTime,

           Id

FROM ....

Now use this

Dimension

FlooredTime

Expression

Sum(Id)

sunny_talwar

Attaching an image and a sample

Capture.PNG

Anonymous
Not applicable
Author

Hi Sunny,

Thanks for your reply.

Yes i got answer i have also done same thing.