topic Re: Regarding Time Related Total in QlikView

Regarding Time Related Total

sarfaraz_sheikh — Fri, 26 Dec 2014 12:09:42 GMT

Dear ALL,

The below is my actual data:

Agent Name Comfort TeaBreak Lunch

A 00:47:21 00:20:30 00:23:53

B 00:35:23 00:16:33 00:29:21

C 00:35:13 00:14:59 00:30:06

I want to calculate the overal time comfort + TeaBreak + Lunch...like below:-

Agent Name Comfort TeaBreak Lunch Overall

A 00:47:21 00:20:30 00:23:53 01:25:50

B 00:35:23 00:16:33 00:29:21 01:21:17

C 00:35:13 00:14:59 00:30:06 01:20:18

How i can do this If will do same ...i am not getting as expected output....i am getting the value point wise 0.31546789 like this

But i want overal total should be in proper time format.....Please help

Sarfaraz

MK_QSL — Fri, 26 Dec 2014 12:16:54 GMT

Load *, Time(Comfort+TeaBreak+Lunch) as Overall Inline

[

Agent Name, Comfort, TeaBreak, Lunch

A, 00:47:21, 00:20:30, 00:23:53

B, 00:35:23, 00:16:33, 00:29:21

C, 00:35:13, 00:14:59, 00:30:06

];

Anonymous — Fri, 26 Dec 2014 12:19:40 GMT

Hi ,

Go to chart properties the select Number Tab , select your sum expression and change number format to Interval then put h:mm:ss in format pattern.

arulsettu — Fri, 26 Dec 2014 12:21:56 GMT

like this

Anonymous — Fri, 26 Dec 2014 12:26:12 GMT

Arul solution will work perfectly .. you just need to replace h:mm:ss TT with h:mm:ss in format pattern to remove AM/PM

sarfaraz_sheikh — Fri, 26 Dec 2014 12:34:43 GMT

Dear Chandel,

Thanks for your reply!!! Your solution is working as expceted ....awesome...really nice thing it was new for me...

Sarfaraz

sarfaraz_sheikh — Fri, 26 Dec 2014 12:35:43 GMT

Yes i got that ....I tried that also ....

Thanks to all for replying ...

Sarfaraz