topic Re: how to convert case into expression in QlikView

how to convert case into expression

Sai78 — Sat, 16 Nov 2024 02:31:06 GMT

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))

Re: how to convert case into expression

Anil_Babu_Samineni — Wed, 11 Sep 2019 02:14:30 GMT

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

Re: how to convert case into expression

Brett_Bleess — Mon, 23 Sep 2019 21:31:57 GMT

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