Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to add distinct in this expression

=count(if(Emp_LE <=35,  [Employee Number]))

4 Replies
nagaiank
Specialist III
Specialist III

=count( Distinct if(Emp_LE <=35,  [Employee Number]))

shawn-qv
Creator
Creator

Or count({<Emp_LE = {"<=35"}>} distinct [Employee Number])

S.

jagan
Partner - Champion III
Partner - Champion III

Hi,

Try this expression without if

=count({<Emp_LE ={'<=35'}>} DISTINCT [Employee Number])

Regards,

Jagan.

engishfaque
Specialist III
Specialist III

Dear TheVilla,

=COUNT(DISTINCT If(Emp_LE <=35,  [Employee Number]))

Kind regards,

Ishfaque Ahmed