topic how to replace if in QlikView

how to replace if

LuisFloresGss — Sat, 16 Nov 2024 18:28:04 GMT

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

Re: how to replace if

yogi_myd — Tue, 23 Jun 2020 14:51:12 GMT

hi,

i am not sure, how the variables are derived.

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

regards

Yogesh.

Re: how to replace if

Brett_Bleess — Wed, 08 Jul 2020 17:38:19 GMT

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/ScriptControlStatements/Switch.htm

Regards,
Brett