topic Problem in Sum() in QlikView

Problem in Sum()

rash_611 — Wed, 17 Sep 2014 07:45:33 GMT

Hi All,

i have derived downtime field as

if(SYSDOWNMINS>1440,(interval(Timestamp(DATETIME)-DayStart( DATETIME),'mm')),SYSDOWNMINS)

when we are giving sum(downtime) in front end we are getting 1384.49.... why is this can any one help me....

Regards,

Grace

anbu1984 — Wed, 17 Sep 2014 07:53:47 GMT

Can you add sample qvw.

rash_611 — Wed, 17 Sep 2014 08:06:27 GMT

PFA

anbu1984 — Wed, 17 Sep 2014 08:15:25 GMT

Change format of downtime to Number. Check attached qvw

danieloberbilli — Wed, 17 Sep 2014 08:17:57 GMT

there seems to be an issue with the last 3 numbers:

marcus_sommer — Wed, 17 Sep 2014 08:24:49 GMT

- Marcus

MarcoWedel — Wed, 17 Sep 2014 10:36:36 GMT

you are adding days and minutes.

interval(Timestamp(DATETIME)-DayStart( DATETIME),'mm'))

gives you an interval with a textual representation in minutes but an underlying numerical value of days.

So you could try:

if(SYSDOWNMINS>1440,Round(Frac(DATETIME)*60),SYSDOWNMINS) as downtime

hope this helps

regards

Marco