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
Anonymous
Not applicable
Author

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

Clever_Anjos
Employee
Employee

Shouldn´t be Field2 - Field1?

Not applicable
Author

Hi , My requirement is like this:-

test.png

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

Hnaks,

D J

Clever_Anjos
Employee
Employee

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

kiranmanoharrode
Creator III
Creator III

Dear Dhiraj,

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

Regards

Kiran Rode

+91 8976977897

Not applicable
Author

no

Not applicable
Author

Try Num(field2) - Num(field1)

Not applicable
Author

Mean like this?

2014-01-14_14h50_13.png

Example Attached.


Not applicable
Author

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

test.png

Thanks,

D J