Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Difference of minute

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

20 Replies
Not applicable
Author

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

Anonymous
Not applicable
Author

Hi Dheraj,

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

Thanks

SHAIK

Anonymous
Not applicable
Author

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

Not applicable
Author

Hi ,

Thanks for your reply,

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

test.png

This may be formate mistake.

Can you kindly help me on this.

Thanks,

D J

Anonymous
Not applicable
Author

HI Dhiraj,

please check at second replay.

thanks

shaik

Clever_Anjos
Employee
Employee

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

Not applicable
Author

HI,

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

Thanks,

D J

Anonymous
Not applicable
Author

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

Clever_Anjos
Employee
Employee

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

Clever_Anjos
Employee
Employee

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