topic Re: Expression Issue in QlikView

Expression Issue

Wed, 10 Sep 2014 14:46:44 GMT

Hi All,

Can you please help me with this question?

let me describe my issue

i have one small table which consists of EmpName,TrainingHours,MinimumHours

i want to create expression for this:i want to calculate only no of employees who have more traininghours when compared respective Minimumhours

I tried to use the expression in Text Objects

Thanks

Suresh

rwunderlich — Wed, 10 Sep 2014 14:59:51 GMT

If the hours are already summarized by EmpName, you should be able to use:

=count(if(TrainingHours > MinimumHours,1))

If the hours are not summed, use an aggr like this:

=count(if(aggr(sum(TrainingHours) > sum(MinimumHours),EmpName),1))

-Rob

Wed, 10 Sep 2014 15:00:52 GMT

My Data looks Like this

EmpName TrainingHours MinimumHours

E001 2 3

E002 2 3

E003 6 3

E004 7 3

Wed, 10 Sep 2014 15:04:11 GMT

Hi Rob,

Thank you so much!

Expression works for me

Suresh