topic Re: Convert into minutes in QlikView

Convert into minutes

vikasmahajan — Fri, 22 Jan 2016 09:28:23 GMT

Hi Team

I have data like this

=Timestamp( .048854166666667,' hh:mm:ss')

o/p is 1:10:21

I want to convert this into minutes 60+10+.21 = 70.21 minutes how to achieve the same.

Thanks

Vikas

Re: Convert into minutes

jonathandienst — Fri, 22 Jan 2016 09:30:13 GMT

Use

Round(.048854166666667 * 1440, 0.01)

1440 is the number of minutes in a day.

Re: Convert into minutes

vikasmahajan — Fri, 22 Jan 2016 09:32:18 GMT

Thanks Jonathan

Vikas

Re: Convert into minutes

PrashantSangle — Fri, 22 Jan 2016 09:33:04 GMT

Hi,

Try with

Interval(.048854166666667,'mm:ss')

Regards,

Re: Convert into minutes

vikasmahajan — Fri, 22 Jan 2016 09:39:11 GMT

thanks this is giving me exact o/p 70.21

Re: Convert into minutes

vikasmahajan — Fri, 22 Jan 2016 09:39:34 GMT

sorry your o/p is 70.35

Re: Convert into minutes

jonathandienst — Fri, 22 Jan 2016 09:43:36 GMT

Well you were not very clear about that. Note that interval formats the value as 70:21, but does not change the underlying value, which will still be .04885416...

Re: Convert into minutes

PrashantSangle — Fri, 22 Jan 2016 09:53:29 GMT

Hi,

As you said

Note that interval formats the value as 70:21, but does not change the underlying value, which will still be .04885416

Kindly can you elaborate?? I am not able to get it.

Regards

Re: Convert into minutes

swuehl — Fri, 22 Jan 2016 09:58:49 GMT

Vikas Mahajan wrote:

sorry your o/p is 70.35

Jonathan is calculating a value like 'minutes.fraction of minutes' from your original value, while max dreamer just formats the original value (fractions of day) like 'minutes:seconds'.

What do you want to get? And what do you want to do with this value? Do you want to change the display of the value (i.e. text representation), or do you want to change the numeric value itself?

edit:

Have a look at

Get the Dates Right

Why don’t my dates work?

Re: Convert into minutes

vikasmahajan — Fri, 22 Jan 2016 10:07:29 GMT

Thanks for all reply ...

Vikas

Re: Convert into minutes

PrashantSangle — Fri, 22 Jan 2016 10:11:30 GMT

Hi,

Now I am more curious about it.

Dear Mr. jontydkpi‌ / Mr. swuehl‌

Please please explain me about it , If possible with example.

I am newbie for this .

Regards,

Prashant

Re: Convert into minutes

swuehl — Fri, 22 Jan 2016 10:18:55 GMT

Well, you need to understand the concept of a DUAL value:

Data Types in QlikView

Then continue reading about formatting and interpretation functions, like num() vs. num#(), Date() vs Date#(), Interval() vs. Interval#() etc.

See the links in my previous post (and keep on reading the referenced links therein).

Re: Convert into minutes

PrashantSangle — Fri, 22 Jan 2016 10:33:27 GMT

Hi,

Thanks for reference link but still I have some stupid question in my mind, but before asking that question better I will read those article and then come back with it .

Regards,