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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)