topic Re: How to aggregate data hours,minutes,second wise in qlikview in QlikView

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

Anonymous — Fri, 10 Mar 2017 11:15:15 GMT

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.

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

Fri, 10 Mar 2017 11:24:05 GMT

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

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

Anonymous — Fri, 10 Mar 2017 11:31:20 GMT

Hi Community,

Any idea how to write expression for above problem?

It's argent

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

sunny_talwar — Fri, 10 Mar 2017 11:38:39 GMT

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,

FROM ....

Now use this

Dimension

FlooredTime

Expression

Sum(Id)

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

sunny_talwar — Fri, 10 Mar 2017 11:43:27 GMT

Attaching an image and a sample

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

Anonymous — Fri, 10 Mar 2017 12:08:52 GMT

Hi Sunny,

Thanks for your reply.

Yes i got answer i have also done same thing.