topic Differance in Time in QlikView

Differance in Time

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

Hi all,

I want to calculate the time difference ,I have a filed like below

opendate ,and I need a new column I like (current time- openeddate ) How to calculate?

May be small issue but am new to Qlik

OpenDate

7/5/2017 11:16

7/5/2017 21:12

7/5/2017 19:10

7/5/2017 21:12

6/29/2017 10:15

6/29/2017 10:27

6/29/2017 10:28

Re: Differance in Time

dan_sullivan — Wed, 12 Jul 2017 12:34:48 GMT

If you are doing it in the script then:

Today() - [openeddate] as 'Age'

Re: Differance in Time

Anil_Babu_Samineni — Wed, 12 Jul 2017 12:38:09 GMT

Are you talking about some thing like below

Load Date(Now(), 'MM/DD/YYYY hh:mm') as CurrentDate,

OpenDate,

Date(Now(), 'MM/DD/YYYY hh:mm') - Date(OpenDate,'MM/DD/YYYY hh:mm') as FieldName

From Source;

Re: Differance in Time

soniasweety — Wed, 12 Jul 2017 12:38:10 GMT

No result used below script

date:
LOAD * Inline [

OpenDate
7/5/2017 11:16
7/5/2017 21:12
7/5/2017 19:10
7/5/2017 21:12
7/5/2017 21:12
6/29/2017 10:15
6/29/2017 10:27
6/29/2017 10:28

]
;

LOAD *
,
Today() - [OpenDate] as 'Age'

Resident date;

Re: Differance in Time

soniasweety — Wed, 12 Jul 2017 12:39:55 GMT

No Anil its not working

Re: Differance in Time

dberkesacn — Wed, 12 Jul 2017 12:41:17 GMT

Hi there are lot of time and date function in Qlik you can go through the help.

http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/date-time-functions.htm

one example: Interval(Now()-Date,'hh:mm').

Daniel

Re: Differance in Time

Anil_Babu_Samineni — Wed, 12 Jul 2017 12:46:09 GMT

Which format you want it as third column ??

Re: Differance in Time

effinty2112 — Wed, 12 Jul 2017 12:49:24 GMT

Hi sony,

Try:

Data:

load

Timestamp#(OpenDate,'M/DD/YYYY hh:mm') as OpenDate;

LOAD * Inline [

OpenDate

7/5/2017 11:16

7/5/2017 21:12

7/5/2017 19:10

7/5/2017 21:12

6/29/2017 10:15

6/29/2017 10:27

6/29/2017 10:28

];

then this straight table gives days,hours, min and sec since reload

OpenDate	=Interval(now(0) - OpenDate,'d - h:m:s')

6/29/2017 10:15	13 - 3:32:54
6/29/2017 10:27	13 - 3:20:54
6/29/2017 10:28	13 - 3:19:54
7/5/2017 11:16	7 - 2:31:54
7/5/2017 19:10	6 - 18:37:54
7/5/2017 21:12	6 - 16:35:54

Cheers

Andrew

Re: Differance in Time

Anil_Babu_Samineni — Wed, 12 Jul 2017 12:51:45 GMT

Use this?

LOAD ClosedDate, OpenDate, NetWorkDays(OpenDate , ClosedDate) as FieldName3;

LOAD Date(Now(), 'MM/DD/YYYY hh:mm') as ClosedDate, Date(Date#(OpenDate,'M/DD/YYYY hh:mm'),'MM/DD/YYYY hh:mm') as OpenDate Inline [

OpenDate

7/5/2017 11:16

7/5/2017 21:12

7/5/2017 19:10

7/5/2017 21:12

6/29/2017 10:15

6/29/2017 10:27

6/29/2017 10:28

];

Re: Differance in Time

dberkesacn — Wed, 12 Jul 2017 12:57:39 GMT

Ye Andrew,

but everything can be calculated at the backend.

Data:

LOAD

OpenDate,

Interval(Now()-OpenDate,'dd-hh:mm') as Delta;

LOAD

Timestamp#(OpenDate,'M/DD/YYYY hh:mm') as OpenDate

;

LOAD * Inline [

OpenDate

7/5/2017 11:16

7/5/2017 21:12

7/5/2017 19:10

7/5/2017 21:12

6/29/2017 10:15

6/29/2017 10:27

6/29/2017 10:28

];

Re: Differance in Time

ahaahaaha — Wed, 12 Jul 2017 12:58:07 GMT

Hi,

As variant at attached file

Re: Differance in Time

soniasweety — Wed, 12 Jul 2017 14:06:13 GMT

thanks all for your inputs

I will check all the possibilities.

Thanks

Sony

Re: Differance in Time

dberkesacn — Wed, 12 Jul 2017 14:18:55 GMT

maybe you can close the topic by choosing one of the answer as a Correct one.

Re: Differance in Time

soniasweety — Wed, 12 Jul 2017 14:21:28 GMT

sure Daniel.thanks