topic Re: Get counts in time in QlikView

Get counts in time

johnan — Wed, 15 Jul 2020 17:23:20 GMT

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

Saravanan_Desingh — Wed, 15 Jul 2020 20:19:45 GMT

Try this.

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

johnan — Thu, 16 Jul 2020 17:14:57 GMT

Hi, thanx 🙂

Got this result: It seems not to be right?

Kushal_Chawda — Thu, 16 Jul 2020 17:41:37 GMT

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

Saravanan_Desingh — Thu, 16 Jul 2020 18:00:23 GMT

@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.

johnan — Thu, 16 Jul 2020 18:13:01 GMT

Aha, is it possible to get it a chart?

Saravanan_Desingh — Thu, 16 Jul 2020 23:46:06 GMT

You can try the expression like.

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

Dimension is: Time

Saravanan_Desingh — Thu, 16 Jul 2020 23:47:22 GMT

Output.

johnan — Fri, 17 Jul 2020 06:34:08 GMT

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