Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator 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
simenkg
Specialist
Specialist

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

ashfaq_haseeb
Champion III
Champion III

Try like this

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

Regards

ASHFAQ

upaliwije
Creator II
Creator II
Author

Thanks

I want to add an If condition to this expression

its_anandrjs

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