topic Re: Interval() formatcode in QlikView

Interval() formatcode

pennetzdorfer — Mon, 14 Oct 2013 09:51:28 GMT

Hi,

I'm using the Interval() function with the format code 'd hh:mm:ss'. The result looks like 6 11:21:33

Is there a way to get 6 days 11 h 21 min 33 sec instead?

Thanks in advance!

Regards,

Florian

Re: Interval() formatcode

swuehl — Mon, 14 Oct 2013 09:58:35 GMT

Yes, by creating a concatenated string with the single items:

=dual(

floor(Interval) &' days ' & hour(Interval) & ' h ' & minute(Interval) & ' min ' & second(Interval) & ' sec'

, Interval

)

Re: Interval() formatcode

Mon, 14 Oct 2013 10:03:52 GMT

yes like above post, use & operator for concatenate

Re: Interval() formatcode

CELAMBARASAN — Mon, 14 Oct 2013 10:11:40 GMT

There is no direct format code as of my knowledge.

May be something like this

LOAD Dual(%CustomFormat, RowNo()) AS %CustomFormat Inline [

%CustomFormat

days

min

sec];

=Concat(Aggr(Subfield(Interval(dateField, 'd|hh|mm|ss'), '|') & ' ' & %CustomFormat, %CustomFormat),' ',%CustomFormat)

=Subfield(Interval(dateField, 'd|hh|mm|ss'), '|', 1) & ' days ' & Subfield(Interval(dateField, 'd|hh|mm|ss'), '|', 2) & ' h ' & Subfield(Interval(dateField, 'd|hh|mm|ss'), '|', 3) & ' min ' & Subfield(Interval(dateField, 'd|hh|mm|ss'), '|', 4) & ' sec'

Re: Interval() formatcode

pennetzdorfer — Mon, 14 Oct 2013 10:41:18 GMT

Thanks! As there is no proper formatcode, swuehls approach seems to be the simplest alternative ...

Re: Interval() formatcode

Tue, 21 Jan 2014 13:29:11 GMT

Hi Swuehl,

Thanks for your easy wayaround to this problem.How ever I was wondering what is the need of 'Dual' here.Please explain and enlighten me.

Many thanks

Regards

Murali Krishna