topic Re: Expression to QV in QlikView

Expression to QV

priyarane — Wed, 21 Oct 2015 13:07:18 GMT

Hi Community,

How to write below expression in qv

(method_original in ('FOU','ADV') and sub_method_original in ('B','C','D') and risk_bucket_original=20,'Strong',

method_original in ('FOU','ADV') and (sub_method_original='SRW' or asset_class_original = 'CLAIM_CIU') and (sub_method_original='SRW' or asset_class_original = 'CLAIM_CIU') and rw_original=2.90 ,'Good') as Credit

Re: Expression to QV

martinpohl — Wed, 21 Oct 2015 13:11:40 GMT

if(match(method_original,'FOU','ADV') and match (sub_method_original,'B','C','D') and risk_bucket_original = 20, 'Strong',

if(match(method_original,'FOU','ADV') and (sub_method_original = 'SRW' or asset_class_original = 'CLAIM_CIU') and (sub_method_original='SRW' or asset_class_original = 'CLAIM_CIU') and rw_original=2.90 ,'Good') as Credit

Regards

Re: Expression to QV

priyarane — Wed, 21 Oct 2015 13:22:13 GMT

So here Match will do like OR?

Re: Expression to QV

martinpohl — Wed, 21 Oct 2015 13:24:04 GMT

match is like "in" in your sql statement

Re: Expression to QV

priyarane — Wed, 21 Oct 2015 13:28:34 GMT

Yes.. IN will do OR performance... so here we have used Match so Match also will do OR, am I right..?

Re: Expression to QV

martinpohl — Wed, 21 Oct 2015 13:37:22 GMT

yes, then it is an or

Re: Expression to QV

Anonymous — Wed, 21 Oct 2015 13:38:25 GMT

Yes. QlikView's "Match" is the equivalent of SQL's "in", and will give you boolean TRUE for each of the values specified as arguments in the "Match"-function.

E.g. QV's Match(method_original,'FOU','ADV') gives the same as SQL's Where method_original = 'FOU' OR method_original = 'ADV', which gives the same as SQL's method_original in ('FOU', 'ADV').

Re: Expression to QV

shelvinpatel — Wed, 21 Oct 2015 13:44:26 GMT

Hi Priya,

It’s subjective of individual’s interpretation and understanding but there is always an explanation for each method otherwise no need of a separate function.

As Martin mentioned that ‘Match’ is like ‘in’ in SQL and you could use ‘OR’ in SQL instead but it won’t be as efficient (always!).

Thanks, Shelvin