Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
upaliwije
Contributor II

Expression

Hi Friends

Pls see what is wrong with the following expression

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

4 Replies
Highlighted
Partner
Partner

Re: Expression

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

Re: Expression

Try like this

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

Regards

ASHFAQ

Highlighted
upaliwije
Contributor II

Re: Expression

Thanks

I want to add an If condition to this expression

Highlighted

Re: Expression

Hi,

With if function

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

Or

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

Regards

Anand