Wrong Total....

[soha1902]

Hi All,

I have one field(Duration) which contains duration in HH:MM:SS format. I took one Text object and put Sum(Duration) expression and it will showing value. But I am not able to understand how Qlikview internally added these values. Its showing the wrong data. Can any one help me to understand this. Please find screenshot:

Thanks.

[morganaaron]

Hi Soha,

Are you using any formatting? y wrapping your sum expression with a Time() function, which should reformat it, though your value looks extremely high to be a summed time expression!

[PradeepReddy]

can you share the application?

[avinashelite]

Hi Soha,

Qlikview is converting you time stamp to number format internally and making it sum.

That's why the result is wrong, convert the time stamp to sec or hr and get the sum out of it, this will give the sum of duration in seconds .

try like this

sum(Interval(Time#(Duration,'hh:mm:ss'),'ss') ) this will give duration sum in seconds

Hope this helps you