Please help me about.

[#1]

Hello everybody!

I am new with Qlik sense. I have one problem. i want to calculate count(Request ID) with 2 conditions: 1 Request Status ='Close'

2. Time spent >=4 hours ( 04:00:00)

what calculation can help me now? Thanks all!

[sunny_talwar · Accepted solution]

May be like this:

Count({<[Request Status = {'Close'}, [Request ID] = {"=[Time Spent] >= MakeTime(4)"}>} [Request ID])

or

Count({<[Request Status = {'Close'}, [Time Spent] = {"$(='>=' & Time(MakeTime(4), 'TimeFieldFormatHere'))"}>} [Request ID])

[#3]

Thanks Sunny T so much. i got it  with the first method.

[sunny_talwar]

Great, I am glad it worked, please consider closing this thread by marking the above response as correct answer

Qlik Community Tip: Marking Replies as Correct or Helpful‌

Best,

Sunny