Count all Users where Sum of a certain value is above n

[#1]

Hello everyone,

I'm very new to qlikview and ran into my first mayor problem that i couldn't find anything really useful to.

What i need to to is count the Amount of people who exceeded a certain Timeframe on a daily basis. So let's say if on Day 2 of the month 0 People exceeded their time the value should be 0 and this should be counting up to always see the total amount of people exeeding their time.

If thought about something like this:

     Sum(Aggr(If(Sum([myTime])>='7200',1,0),[Name],[FirstOfMonth]))

but it somehow won't give me the results i wish to see.

Does anyone have a good idea on how to solve this?

Best Regards

Sebastian

[Anonymous]

Hi Sebastian,

Could you attach one example to see your data and your calculation on real time?

Regards.

[Digvijay_Singh]

Any specific reason you are using single quote in if statement for numeric sum? Not sure if that is causing any difference?

[Kushal_Chawda]

may be try this

=Count({<Name ={"=Sum([myTime])>7200"}>}Name )

[avinashelite]

try like

if(Sum([myTime])>7200,Count(Name))

[pho3nix90]

Hi Sebastian,

If you could give a brief example of where you are trying to accomplish this? I assume it's in a straight table.

There are multiple ways of how you can tackle this:

Count(if(Sum([myTime]) > 7200, Name))

Or you could do

Count({<[myTime]) = {">7200"}> Name}

If you can give an example of what your data looks like, I can give better examples if the above doesn't work.