Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Sebastian,
Could you attach one example to see your data and your calculation on real time?
Regards.
Any specific reason you are using single quote in if statement for numeric sum? Not sure if that is causing any difference?
may be try this
=Count({<Name ={"=Sum([myTime])>7200"}>}Name )
try like
if(Sum([myTime])>7200,Count(Name))
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.