topic Re: time function - minutes interval in QlikView

time function - minutes interval

ilanbaruch — Tue, 17 Feb 2015 08:09:56 GMT

hi I want to measure game session time in minutes ,

in my script i tried the following :

1. EndTime - StartTime as GameDuration,
2. Interval( EndTime - StartTime,'HH:MM')as GameDurationF,
3. Num(Second(EndTime)) - Num(Second(StartTime)) as GameDurationN,
4. //interval( EndTime - StartTime, 'hh:mm')as GameDuration,

in the layout I tried:

1. =Interval( EndTime - StartTime,'HH:MM:SS')

none of them brings back a true value of minutes

any ideas ???

Re: time function - minutes interval

alexandros17 — Tue, 17 Feb 2015 08:16:34 GMT

Try with

Date(EndDate - StartDate, 'hh:mm:ss')

Re: time function - minutes interval

PrashantSangle — Tue, 17 Feb 2015 08:24:13 GMT

Hi,

If both are in date format then Interval() must work for you.

try with date#() and timestamp#()

try like

interval(timestamp#(EndTime,'DD/MM/YYYY hh:mm:ss') - timestamp#(StartTime,'DD/MM/YYYY hh:mm:ss'),'D hh:mm')

Regards

Re: time function - minutes interval

ilanbaruch — Tue, 17 Feb 2015 08:41:31 GMT

thank you!

Re: time function - minutes interval

ilanbaruch — Tue, 17 Feb 2015 11:27:55 GMT

hi,

now I have a GameDuration field in the script.

in my layout I want to present avg (GameDuration ) in a bar chart but result comes not true.

thank you for your help