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

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
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?

Labels (1)
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)