topic Re: Time Spent in One day in QlikView

Time Spent in One day

jyothish8807 — Fri, 26 Jul 2013 09:58:59 GMT

Hi,

I want ot setup an formula for the mentioned scenario:

Suppose I have Four coloum.

Now I want to find out the Whole time spent by the people for particular day .

Regards

Jyothish KC

swuehl — Fri, 26 Jul 2013 10:16:01 GMT

Please check the solution I proposed in this thread.

Gysbert_Wassenaar — Fri, 26 Jul 2013 10:22:28 GMT

Try something like:

interval(rangesum(sum({<Mode={'Out'}>}Time),-sum({<Mode={'In'}>}Time)),'hh:mm')

if your Time field contains strings instead of numeric times you'll have to make times of them first. This is best done in the script:

load

Name,

Date,

time#(Time,'h:mmtt') as Timem

Mode

from ...somewhere...;