topic Sum(value) in different hour in QlikView

Sum(value) in different hour

pascos88 — Tue, 23 Feb 2016 14:59:46 GMT

Hello everyone,

I have the hour field and for each 15 minuts a value.

I need to sum the value for each hours. In the immage attached for example I need to have a value 0.21 for 09, 0.62 for 10 etc.

Thanks for any help

Pasquale

sunny_talwar — Tue, 23 Feb 2016 15:01:29 GMT

May be use a calculated dimension:

Calculated Dimension: Hour(Hour)

Expression: Sum([KWh Real])

swuehl — Tue, 23 Feb 2016 15:01:39 GMT

Just replace your currently used dimension with a calculated dimension:

=Hour( YourHourField)

rubenmarin — Tue, 23 Feb 2016 15:04:08 GMT

Hi Pascuale, you can create a dimension with only the hour part:

Hour(Time_Field)

Can be a calculated dimension or a field created in script.

Then just an expression like Sum(Value_Field) should return the values grouped by hour

sunny_talwar — Tue, 23 Feb 2016 15:10:45 GMT

Alternatively, calculate Hour in the script

SET TimeFormat='hh:mm';

Table:

LOAD Hour as Time,

Hour(Hour) as Hour,

[KWh Real]

Inline [

Hour, KWh Real

09:00, 0.01

09:15, 0.03

09:30, 0.06

09:45, 0.11

10:00, 0.16

10:15, 0.30

10:30, 0.14

10:45, 0.02

];

Anonymous — Tue, 23 Feb 2016 15:29:52 GMT

Hi,

try

in your dimension Hour(hour) ,

in your expessions Sum([KWh Real])

Regards.