Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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