# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for
Did you mean:
Highlighted
Creator III

## Get counts in time

Hi ,how can i get the sum of counts if a time is more than 20 minutes beetwen the post?
Example:

10:10
10:04
10:10
10:31
10:40
11:01
Here is 2 post that is 20 minutes or more

8 Replies
Highlighted
Specialist III

Try this.

``=Count(Aggr(If(Interval(Time-Above(Time),'mm')>=Time#(20,'mm'),Time),Time))``
Highlighted
Creator III

Hi, thanx 🙂

Got this result: It seems not to be right?

Highlighted
MVP

try below. if not post us the expected output

=Count(Aggr(If(Interval(Time-Above(total Time),'mm')>=Time#(20,'mm'),Time,anv.flytt),Time))

Highlighted
Specialist III

@johnan  My expression should be used in a Text box. Not in a Chart.

Please try it in a Text box and let me know.

Highlighted
Creator III

Aha, is it possible to get it a chart?

Highlighted
Specialist III

You can try the expression like.

``If(Time-Above(Time)>=Time#(20,'mm'),1)``

Dimension is: Time

Highlighted
Specialist III

Output.

Highlighted
Creator III

Hi ,here is my result

The Start and Stopp is based on Min and Max (Tid) per User and the tot tid is bases on  (Interval(Stopp-Start,'hh:mm'))

If i just do a simpled table based on user P452 i got this and it's correct:

And the expresssion is:

So i want this to shown in my first table above 🙂

if([Anv. flyttar gods]='P452', If(Tid-Above(Tid)>=Time#(20,'mm'),1))