Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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])
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])
Thanks Sunny T so much. i got it with the first method.
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