Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
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

shaik_basha
Creator III
Creator III

Hi Dheraj,

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

Thanks

SHAIK

shaik_basha
Creator III
Creator III

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

shaik_basha
Creator III
Creator III

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

shaik_basha
Creator III
Creator III

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