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