topic Re: pls correct the expression in QlikView

pls correct the expression

Thu, 21 Aug 2014 12:10:31 GMT

hi all

I have employee acheivemen field as below

when i am using the expression

if([Employee Acheivement] >= 35, count([Employee Number])) I am getting '-' instead of value

Pla help

tresB — Thu, 21 Aug 2014 12:11:55 GMT

=Count(if([Employee Acheivement] >= 35, [Employee Number]))

senarath — Thu, 21 Aug 2014 12:13:13 GMT

Hi,

Try this;

=Count(if([Employee Acheivement] > 35,[Employee Number]))

thanx

joshabbott — Thu, 21 Aug 2014 12:14:12 GMT

This is because the first record it is looking at per the if statement is not >= 35. Try something like:

=count({[Employee Achievement]={">=35"}} [Employee Number])

maleksafa — Thu, 21 Aug 2014 12:14:16 GMT

you need to evaluate the if condition inside of the aggregation function count, like what tresesco said.