What is wrong with my set expression?

[carolinarodrigues]

Hi everyone,

I am new here and I am trying to build a chart that should count unique employee number plus a lot of filters.

Can anyone please check what I am doing wrong with the following set expression?

Count distinct[Employee Number]{<[Employee Type]={'Permanent','Casual','Union'},[Status]={'Active','Leave of absence'},[Updated BU]-={'NONE'}>}[Employee Number])

Thank you in advance

[Ray_Strother]

Hello , It look like you are missing a corresponding ")" . You have one at the end of the statement , but the opposite doesn't exist. Below are some resources that may help:
Set Analysis: taking the next steps - Qlik Sense

https://www.youtube.com/watch?v=sB71KUcnwls



Set Analysis - Part 2 - Cool Stuff You Can Do (video)

https://community.qlik.com/t5/Qlik-Sense-Documents/Set-Analysis-Part-2-Cool-Stuff-You-Can-Do-video/t...


https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAn...

[vinieme12 · Accepted solution]

apart from the Opening bracket for Count()  , there is redundant field name 

Corrections highlighted

Count ( distinct[Employee Number]{<[Employee Type]={'Permanent','Casual','Union'},[Status]={'Active','Leave of absence'},[Updated BU]-={'NONE'}>}  distinct   [Employee Number])

Your final  expression should be as below

Count ( {<[Employee Type]={'Permanent','Casual','Union'},[Status]={'Active','Leave of absence'},[Updated BU]-={'NONE'} >}  distinct   [Employee Number])

[carolinarodrigues]

Thank you so much @vinieme12 ! You saved my day!