how to replace if

[LuisFloresGss]

Hello everyone, is there a way to replace this if with a CASE? this IF is a metric on a pivot table

Hello everyone, is there a way to replace this if with a CASE? 
this IF is a metric on a pivot table

my problem is that I have this IF in QlikView version 8 and it doesn't solve the IF

[yogi_myd]

hi,

i am not sure, how the variables are derived.

But i suggest to go for the functions Pick and Match. 

regards

Yogesh.

[Brett_Bleess]

You can also check the following Help link, not sure if this is what you need or not, but wanted to pass it along:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

Regards,
Brett