Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression not showing values?

Hi,

I have data with below

Dimension: EmployeeName

Expression: =If(MixMatch(Outcome='Update',

                       'Updated to All',

                         'Updated to Outstanding'),Count(ID))

But the data is showing blank values under expression as there is data in the database. can anyone please suggest me is there any error in expression?

2 Replies
maxgro
MVP
MVP

I think

Outcome='Update'             is true or false --> -1 or 0

MixMatch(-1/0, .........)        always 0

Count(ID)                           never

nagaiank
Specialist III
Specialist III

Try

Count(If(MixMatch(Outcome,'Update','Update to All','Updated to Outstanding'),ID)