Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
adias102
Contributor III
Contributor III

Count events if interval between 2 dates is less than x seconds

Spoiler
Hi all,

I need to count the events for which the interval between start and end date is less than 40 seconds.
Start and end are datetime values dd/mm/yyyy hh:mm:ss. 

Since I'm very new to Qlik Sense I tried to do it step by step.
1st step - calculating the interval between the 2 dates: interval(End- Start, 'ss') as A
2nd step - trying an IF calculation: if(num#(A) < 40, 1, 0) as B

I've tried several ways to count the events based on these 2 steps with no success.
sum(B) returns 0
count(if(num#(A)<40, Event)) also returns 0

Thank you.
Labels (2)
5 Replies
Taoufiq_Zarra

you just need to add :

 if(Time(end-start,'hh:mm:ss')>'00:00:40',1,0) as B,
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
adias102
Contributor III
Contributor III
Author

Hi,

I used this formula in a table chart object and it works fine. also, I have the correct value at the total line.

I want to add a KPI object to display the same value. How can I create a KPI based on a calculated measure?

 

I want the total value of B (shown in the red rectangle) as a KPI by itself.B.PNG

 
Taoufiq_Zarra

if I understand correctly

=sum(B)

?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
adias102
Contributor III
Contributor III
Author

Hi,

I think it should be something as simple as that but I get 0.

Taoufiq_Zarra

can you share your qlik file or a sample data to look

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉