topic Re: Date difference in separate field in QlikView

Date difference in separate field

Mon, 23 Dec 2013 06:28:07 GMT

Hi,

I have two fields Date Sent and Received

I want the difference of two fields in an another field say "Difference"

i.e Date Sent - Date Received = Difference

So that i can use the difference field in another chart as an expression.

I want the difference as number of days.

I have attached the Date.qvw.

Thanks in advance,

Keerthi

Re: Date difference in separate field

Anonymous — Mon, 23 Dec 2013 06:38:34 GMT

If the format of the fields is date , then you can simply subtract them and get the difference,

I format is not right the make those fields in date format by date, date \# or makedate functions and then substract them..

Regards

Nitin

Re: Date difference in separate field

Mon, 23 Dec 2013 06:44:23 GMT

Hi Keerthi,

(Date Sent - Date Received) didnt worked?

Re: Date difference in separate field

Mon, 23 Dec 2013 06:45:09 GMT

you Can use "Interval" function for this purpose

try it you will Succeed

Re: Date difference in separate field

Mon, 23 Dec 2013 06:46:40 GMT

In scripting or Back end

Interval(Date Sent - Date Received) as Difference

Re: Date difference in separate field

Mon, 23 Dec 2013 06:49:01 GMT

hi,

Use This Expression,

=sum(num(ows_DateSentToUnderwriter)-num(ows_DateReceivedAon))

Re: Date difference in separate field

Mon, 23 Dec 2013 06:51:25 GMT

In scripting or Back end

Interval(Date Sent - Date Received, D hh:mm:ss) as Difference

this will give you in Days

Re: Date difference in separate field

qlikpahadi07 — Mon, 23 Dec 2013 07:04:12 GMT

you can simple write ows_DateSentToUnderwriter - ows_DateReceivedAon in your script.

Re: Date difference in separate field

Anonymous — Mon, 23 Dec 2013 07:24:12 GMT

if your date that is sent and recevied are in format MM/DD/YYYY

just check this script it gives correct diffrence in no of days.

load * Inline

[

sent,received

1/1/2013, 9/2/2013

2/1/2013, 11/1/2013

];

LOAD Date(received) - Date(sent) as daydiff

resident a;

DROP Table a;

anant

Re: Date difference in separate field

Mon, 23 Dec 2013 07:59:22 GMT

u can try the below in straight table :

Dimension:

Col1 -> ows_DateSentToUnderwriter

co2 -> ows_DateReceivedAon

Expression:

ows_DateSentToUnderwriter - ows_DateReceivedAon

Re: Date difference in separate field

Mon, 23 Dec 2013 08:59:55 GMT

It comes in straight table. but i want the date difference for some other dimension

Ex: For UNDERWRITER.

I want it in a bar chart, with Underwriter as dimension and and average of date difference as expression.

Please help me with this

Regards,

Keerthi

Re: Re: Date difference in separate field

tresB — Mon, 23 Dec 2013 09:08:42 GMT

May be like attached sample?

PFA

Re: Date difference in separate field

Anonymous — Mon, 23 Dec 2013 09:09:08 GMT

Create the difference of dates in script instead at front end.

Re: Date difference in separate field

Mon, 23 Dec 2013 09:19:20 GMT

Thanks a lot Tresesco