Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Please help me about.

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!

1 Solution

Accepted Solutions

Re: Please help me about.

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 Replies

Re: Please help me about.

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])

Not applicable

Re: Please help me about.

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

Re: Please help me about.

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