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: 
1 Solution

Accepted Solutions
prma7799
Master III
Master III

Try like this

sum(if( "market"='DOMESTIC', if(not WildMatch( party_name ,'ALEX*' ), (basicvalue))))

View solution in original post

3 Replies
prma7799
Master III
Master III

Try like this

sum(if( "market"='DOMESTIC', if(not WildMatch( party_name ,'ALEX*' ), (basicvalue))))

tresesco
MVP
MVP

Try like:

sum({<market={'DOMESTIC'}, party_name - ={'ALEX*'} >} basicvalue)

prma7799
Master III
Master III

or try

sum(if(not WildMatch( party_name ,'ALEX*' )  and "market"='DOMESTIC' ,basicvalue))