This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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 ???
View solution in original post
Date(EndDate - StartDate, 'hh:mm:ss')
If both are in date format then Interval() must work for you.
try with date#() and timestamp#()
interval(timestamp#(EndTime,'DD/MM/YYYY hh:mm:ss') - timestamp#(StartTime,'DD/MM/YYYY hh:mm:ss'),'D hh:mm')
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