topic Re: Format interval function in QlikView

Format interval function

sergio0592 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I'd like to format inteval in order to get the output below (with XX d, XX h, XX m instead XX:XX:XX)

Is it possible?

Regards

swuehl — Fri, 09 Jun 2017 19:13:17 GMT

=floor(145.5) & ' days ' & hour(145.5) & ' hours ' & Minute(145.5) & ' minutes'

swuehl — Fri, 09 Jun 2017 19:16:03 GMT

You can also create a variable in your script:

SET vInterval2 = Dual(floor($1) & ' days ' & hour($1) & ' hours ' & Minute($1) & ' minutes',$1);

and then use

=$(vInterval2(145.5))

sergio0592 — Fri, 09 Jun 2017 19:51:48 GMT

Thanks for your reply but what is $1 in your formula?

swuehl — Fri, 09 Jun 2017 19:54:30 GMT

Thats denoting the first parameter in