Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ilanbaruch
Specialist
Specialist

time function - minutes interval

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 ???

1 Solution

Accepted Solutions
ilanbaruch
Specialist
Specialist
Author

4 Replies
alexandros17
Employee
Employee

Try with

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

PrashantSangle

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

Great dreamer's dreams never fulfilled, they are always transcended.
ilanbaruch
Specialist
Specialist
Author

thank you!

ilanbaruch
Specialist
Specialist
Author

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