topic Re: Calculate Day and time in QlikView

Calculate Day and time

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

how can convert 23142 into day and time

Re: Calculate Day and time

MarcoWedel — Fri, 26 Jan 2018 16:51:31 GMT

That might depend on the result you would expect.

Re: Calculate Day and time

pradosh_thakur — Fri, 26 Jan 2018 18:06:14 GMT

Not sure you can covert this to any time as there is no decimal part of the number present here but you can try timestamp() function .. It will change it to a date with timestamp as 00:00:00.. anyways what is the output you want to see?

Re: Calculate Day and time

Thiago_Justen_ — Sat, 27 Jan 2018 01:16:44 GMT

As Pradosh's response you can use timestamp function for that. But your output with this integer number will look like this:

Re: Calculate Day and time

rakeshkumar1890 — Sat, 27 Jan 2018 06:42:35 GMT

I have used online tool to convert this number into HH:MM:SS

then I got 06:25:42

How I can calculate in qlikview

format : DD:HH:MM:SS

Re: Calculate Day and time

pradosh_thakur — Sat, 27 Jan 2018 07:00:00 GMT

I would use this

=Interval(23142/86400,'DD:hh:mm:ss')

replace your field with 23142

Re: Calculate Day and time

sahadevpatil140 — Sat, 27 Jan 2018 07:29:37 GMT

I have used following expression to calculate Days and Time from given DATENUMBER 23142

=Date(23142,'DD-MM-YYYY HH:MM:SS TT') convert into Date

=day(Date(23142,'DD-MM-YYYY HH:MM:SS TT')) To find Day

=Time#(date(23142,' HH:MM:SS TT')) to find Time

Following attachments shows expected result

Regards,

Sahadev Patil

Re: Calculate Day and time

rakeshkumar1890 — Sat, 27 Jan 2018 09:41:15 GMT

Thanks all of you

I got the database provides to different values in different conditions

@@Pradosh - I have already applied interval function but due to different values in database I can't map.

I got the solution what I want

Thanks.

Re: Calculate Day and time

Thiago_Justen_ — Sat, 27 Jan 2018 10:25:07 GMT

Sound's good Rakesh. By the way, if your problem is already solved, please, close the thread.

Cheers

Re: Calculate Day and time

MarcoWedel — Sat, 27 Jan 2018 20:52:18 GMT

what is your solution?

Re: Calculate Day and time

rakeshkumar1890 — Tue, 30 Jan 2018 07:59:11 GMT

Thanks for the solution

It was

Interval(23142/(24*60),'dd:hh:mm:ss')

Because Number was in minutes

Thank you so much all of your inputs.

Re: Calculate Day and time

pradosh_thakur — Tue, 30 Jan 2018 08:04:14 GMT

If the number was in minutes you wont get the answer as 06:25:42 . Anyways please close the thread by marking answer correct and helpful.

Re: Calculate Day and time

MarcoWedel — Tue, 30 Jan 2018 22:23:41 GMT

Hi,

another solution to this might be:

Interval(Interval#(Minutes,'m'),'dd:hh:mm:ss')

hope this helps

regards

Marco