topic Re: Expression in QlikView

Expression

upaliwije — Mon, 08 Dec 2014 09:54:42 GMT

Hi Friends

Pls see what is wrong with the following expression

sum( if(GROUP_CODE = {'MA','MB','MC','MD','ME'} and TYPE='S',[BUDGET]))

simenkg — Mon, 08 Dec 2014 09:55:57 GMT

sum({<GROUP_CODE = {'MA','MB','MC','MD','ME'}, TYPE={'S'}>}[BUDGET])

ashfaq_haseeb — Mon, 08 Dec 2014 09:57:17 GMT

Try like this

sum({<GROUP_CODE = {'MA','MB','MC','MD','ME'},TYPE={'S'}>}[BUDGET]))

Regards

ASHFAQ

upaliwije — Mon, 08 Dec 2014 10:08:13 GMT

Thanks

I want to add an If condition to this expression

its_anandrjs — Mon, 08 Dec 2014 10:26:31 GMT

Hi,

With if function

=sum( if(Match(GROUP_CODE,'MA','MB','MC','MD','ME') and TYPE='S',[BUDGET] ))

=sum( if(WildMatch(GROUP_CODE,'MA','MB','MC','MD','ME') and TYPE='S',[BUDGET] ))

Regards

Anand