topic Difference of minute in QlikView

Difference of minute

Tue, 14 Jan 2014 12:32:39 GMT

Hi All,

I have two field that value is in minute i.e Field1:- 32 (Min,) Field2:- 44 (Min)

I need to find the difference in this , when I am doing Field1-Field2 , it showing "- "

Kindly help me on this.Only number is there.

Note:- Min is not present in Field value.

Thanks,

D J

Re: Difference of minute

Anonymous — Tue, 14 Jan 2014 12:43:20 GMT

have you tried stripping the blank between - 32 and - 44?

Re: Difference of minute

Clever_Anjos — Tue, 14 Jan 2014 12:49:15 GMT

Shouldn´t be Field2 - Field1?

Re: Difference of minute

Tue, 14 Jan 2014 13:28:14 GMT

Hi , My requirement is like this:-

I need to get the differen between Total Time and Pending Duration.

Hnaks,

D J

Re: Difference of minute

Clever_Anjos — Tue, 14 Jan 2014 13:34:21 GMT

[Total Time] - [Pending Duration] is not working?

Re: Difference of minute

kiranmanoharrode — Tue, 14 Jan 2014 13:34:31 GMT

Dear Dhiraj,

Please post sample application. it will be helpful to understand your problem

Regards

Kiran Rode

+91 8976977897

Re: Difference of minute

Tue, 14 Jan 2014 13:42:11 GMT

Re: Difference of minute

Tue, 14 Jan 2014 13:43:40 GMT

Try Num(field2) - Num(field1)

Re: Re: Difference of minute

Tue, 14 Jan 2014 13:51:32 GMT

Mean like this?

Example Attached.

Re: Difference of minute

Tue, 14 Jan 2014 14:01:57 GMT

Can't share the data due to confidentiolaty, But posting a sample data.

Thanks,

D J

Re: Difference of minute

Tue, 14 Jan 2014 14:16:42 GMT

no repeated coloumn be there in Total time, Al should be combined

Re: Re: Difference of minute

Anonymous — Tue, 14 Jan 2014 14:57:21 GMT

Hi Dheraj,

Please find the attachment of application according to your requirement,if you have any issue please let me know.

Thanks

SHAIK

Re: Difference of minute

Anonymous — Tue, 14 Jan 2014 15:10:43 GMT

HI Dhiraj,

in place adding extra Total Time,we can add Flag also,in expression we can handle with flag,please find the attachment of application below.

Thanks

SHAIK

Re: Difference of minute

Tue, 14 Jan 2014 15:13:14 GMT

Hi ,

Thanks for your reply,

I have executed the method providede by you and got the below result (seems somthing wrong there).

This may be formate mistake.

Can you kindly help me on this.

Thanks,

D J

Re: Difference of minute

Anonymous — Tue, 14 Jan 2014 15:29:43 GMT

HI Dhiraj,

please check at second replay.

thanks

shaik

Re: Difference of minute

Clever_Anjos — Tue, 14 Jan 2014 15:36:50 GMT

Does any field of this are "interval" or are you using interval function anywhere?

Re: Difference of minute

Wed, 15 Jan 2014 06:45:34 GMT

HI,

Yes I am using Interval Function to find the Total Time .

Thanks,

D J

Re: Difference of minute

Anonymous — Wed, 15 Jan 2014 07:15:19 GMT

Hi dhirah,

do one thing,sort a your data Ascending according to your TICKET NUMBER Field,after write a what ever the condition yesterday i written.

it will be work.

Thanks

SHAIK

Re: Difference of minute

Clever_Anjos — Wed, 15 Jan 2014 11:07:31 GMT

Please format last column as a interval. 9706 minutes are 6.74 days

Re: Difference of minute

Clever_Anjos — Wed, 15 Jan 2014 11:07:40 GMT

Please format last column as a interval. 9706 minutes are 6.74 days