Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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])

Highlighted

Re: Expression

Try like this

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

Regards

ASHFAQ

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