how to convert case into expression

[Sai78]

Can you help me how to convert the below condition into qlik expression ?

CASE WHEN ISNULL(ManualBV_Outcome,'') = ISNULL(AutomatedBV_Outcome,'')
AND ISNULL(ManualBV_Outcome_Reason,'') = ISNULL(AutomatedBV_Outcome_Reason,'') THEN 'match'
ELSE 'nomatch' END AS Manual_Discripency_Case_Status

-----------------

select eBVDiscrpt_Parent_Case_Id

where Manual_Discripency_Case_Status = 'Match'

I tried doing this but no luck --

=COUNT ( DISTINCT IF((ManualBV_Outcome_Reason = AutomatedBV_Outcome_Reason ) AND (ManualBV_Outcome = AutomatedBV_Outcome ) , eBVDiscrpt_Parent_Case_Id))

[Anil_Babu_Samineni · Accepted solution]

Perhaps this? I assume, you have real null values

If(ISNULL(ManualBV_Outcome) = ISNULL(AutomatedBV_Outcome)
AND ISNULL(ManualBV_Outcome_Reason) = ISNULL(AutomatedBV_Outcome_Reason), 'match', 'nomatch') as Manual_Discripency_Case_Status

After that, you can call it out for set analysis like

COUNT ({<Manual_Discripency_Case_Status={'match'}>} DISTINCT eBVDiscrpt_Parent_Case_Id) // For match records

COUNT ({<Manual_Discripency_Case_Status={'nomatch'}>} DISTINCT eBVDiscrpt_Parent_Case_Id) // For no-match records

[Brett_Bleess · Accepted solution]

Sunitha, did Anil's post help, or are you still trying to figure things out?  If that was what you needed, do not forget to give Anil credit by using the Accept as Solution button to mark his post as the solution.  If you figured out something else, consider posting what you did and mark that.  If you still need help, leave an update.

Regards,
Brett