What is the error in this set expression? - Qlik Community

Report Inappropriate Content · ‎2014-08-21

HI All

i am using the below set expression to fing the count of employees who belongs to 90 and 100 but it is showing '-' for me?

=if(sum( distinct EmployeeBucket >90) and sum(distinct EmployeeBucket <=100),Count( DISTINCT [Employee Number]))

pls help me to correct issue

Thanks in advance

tresesco · ‎2014-08-21

Try like:

=if(sum( distinct EmployeeBucket )>90 and sum(distinct EmployeeBucket )<=100,Count( DISTINCT [Employee Number]))

Anonymous · ‎2014-08-21

Hello,

Please check your condition sum( distinct EmployeeBucket) is returning values between 90 to 100, only then this condition should work

Regards,

Nita Prasad

PrashantSangle · ‎2014-08-21

Hi,

What values are there in EmployeeBucket??

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2014-08-21

Hi TheVIlla,

=Count(DISTINCT{$<EmployeeBucket={'>90 <=100'}>}EmployeeBucket)

use this expression in text object may gives the result.