Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
jblomqvist
Specialist
Specialist

Hi friends, How to show values in Minutes? I have the data in Seconds

Hi all,

I have some data where the time difference is calculated in seconds

DateDuration (Seconds)
01/03/20171403
13/03/201735
10/03/201718
01/01/20171026

At the moment I am calculating as Sum(Duration) / 60.

This works for values over a minute(e.g. for the first and last values in the above table) but it doesn't show me the values in seconds if the duration is less than a minute (e.g. 2nd and 3rd row above).

Any idea how I can get around this properly?

5 Replies
sunny_talwar

May be like this

Interval(Interval#(Sum(Duration), 'ss'), 'mm:ss')

Capture.PNG

swuehl
MVP
MVP

Maybe

If(Sum(Duration)>=60, Sum(Duration) / 60, Sum(Duration) )

?

But this will mix values minutes and seconds in the same field, I don't recommend to do that.

Maybe just show


Sum(Duration) / 60


with decimal places?

rahulpawarb
Specialist III
Specialist III

Hello John,

Referring solution given by stalwar1‌ I have prepared sample application. Please find attached herewith.

Regards!

Rahul

Not applicable

Hi,

try this in your expression

=Num(Duration/60,0) & ':' & mod(Duration,60)

hope this helps

thanks

Not applicable

Hi,

if you want to show two digits in  min and secs

try this in your expression

=Num(Duration/60,00) & ':' & Num( mod(Duration,60),00)

hope this helps

thanks