Count with condition less more value and set

Wed, 16 Jan 2013 08:28:01 GMT

Hello!

The task is following:

Name - emplyee name;

Type - work type Day, Night;

Data - number of working iterations for emplyee;

The issue is in to show in Text Object how many employees are complete the planned iterations, i.e. >=200;

The expression to calculate it Avg({<Type={Night}>}Data)+Avg({<Type={Day}>}Data), further I have to add the condition that we are looking for that number of employees that have more than 200 iterations, so I add >=200. And further I have to count only those values in text object.

So I do the following: Sum(Aggr(If((Avg({<Type={Night}>}Data)+Avg({<Type={Day}>}Data))>=200,1,0),Name)), i.e. means that I receive the data with 0 if the value less than 200, and 1 if more than 200, after that I sum the values and receive the needed Value.

The question is that: is there any other more simple way to solve this task in Text Object?

Thanks in advance!

Re: Count with condition less more value and set

sujeetsingh — Wed, 16 Jan 2013 08:38:47 GMT

Can use if statement.

Re: Count with condition less more value and set

Wed, 16 Jan 2013 08:40:25 GMT

Hi! Could you please provide the working sample of your idea ?

topic Re: Count with condition less more value and set in QlikView

Count with condition less more value and set

Re: Count with condition less more value and set

Re: Count with condition less more value and set