topic Re: Expression in QlikView

Expression

priyarane — Thu, 29 Oct 2015 15:00:20 GMT

Hi Community,

how to write below expression

bis_entity_type_new in ('SME_EU', 'SME_EU_RET') THEN rwa/0.7619

tamilarasu — Thu, 29 Oct 2015 15:13:39 GMT

Try like

If(match(bis_entity_type_new,'SME_EU','SME_EU_RET'),rwa/0.7619)

vishsaggi — Thu, 29 Oct 2015 15:35:09 GMT

You can also use wildmatch here for case insensitive search.

If(wildmatch(bis_entity_type_new,'*SME_EU*','*SME_EU_RET*'), rwa/0.7619)

jagan — Thu, 29 Oct 2015 15:40:22 GMT

HI,

Try this expression

=Sum({<bis_entity_type_new ={'SME_EU', 'SME_EU_RET'}>} rwa) /0.7619

=Sum({<bis_entity_type_new ={'SME_EU', 'SME_EU_RET'}>} rwa/0.7619)

Hope this helps you.

Regards,

Jagan.