topic I am trying to count duration bigger than hh:00 45mins in QlikView

I am trying to count duration bigger than hh:00 45mins

laf4t — Wed, 25 Nov 2020 16:16:04 GMT

My sample data is

Type of service Duration ID

Love 00:45 002

Kiss 00:30 004

Kiss 00:46 003

Love 00:30 009

Hug 00:44 011

Hug 00:48 023

I'm trying to count the amount of services that are 'Love' which duration are more than 00:45. I have this code written but its not pulling the duration >= 00:45, its pulling all of them

count(if([Type of Service] = 'Love' and [Duration] >= '00:45' , [ID]))

Re: I am trying to count duration bigger than hh:00 45mins

Saravanan_Desingh — Fri, 12 Jun 2020 17:43:33 GMT

Your input header shows [Type of service]. But your Expression shows [Type of Service] . Can you check the upper case?

Your query is working for me.

Re: I am trying to count duration bigger than hh:00 45mins

laf4t — Fri, 12 Jun 2020 17:51:03 GMT

Sorry, i figured it out sec after I added this posted. What worked for me is

count(if([Type of service] = 'Love' and [Duration] >= num(45) , [ID]))

I was going to delete this post but I'll leave it on here just in case someone else needs it.

Re: I am trying to count duration bigger than hh:00 45mins

laf4t — Fri, 12 Jun 2020 18:00:58 GMT

but then I am trying to multiply by 90 like this below

count(if([Type of service] = 'Love' and [Duration] >= num(45) , [ID]*90))

but this is not working for me .. please help

Re: I am trying to count duration bigger than hh:00 45mins

Saravanan_Desingh — Fri, 12 Jun 2020 18:18:32 GMT

Are you trying to multiply 90 with ID or with the Count?

Re: I am trying to count duration bigger than hh:00 45mins

laf4t — Fri, 12 Jun 2020 19:59:10 GMT

I am trying to multiply with the count

Re: I am trying to count duration bigger than hh:00 45mins

sergio0592 — Fri, 12 Jun 2020 20:27:31 GMT

Hi, try with :

=count(if(num(Duration)>='$(=45/1440)' and [Type of service]='Love',ID))

Re: I am trying to count duration bigger than hh:00 45mins

Saravanan_Desingh — Fri, 12 Jun 2020 21:28:15 GMT

then try this.

count(if([Type of service] = 'Love' and [Duration] >= num(45) , [ID]))*90