Include and Exclude in Expression

[JamesR]

I have a situation where I need to sum data that falls into a certain stage, but exclude certain names.

Today I have this running, Sum({StageName={'Closed Won'}>}TotalPrice

Now I wish to exclude any records where the field Opportunity.Name contains 'renewal' or 'Renewal'

What I was trying to do was to insert that expression with something like

If(Not Match(Opportunity.Name, 'renewal', 'Renewal'), Sum({StageName={'Closed Won'}>}TotalPrice)

I can't seen to get this to work no matter how many ways I chop it up.

[rwunderlich]

Sum({StageName={'Closed Won'}, Opportunity.Name-={"renewal"}>}TotalPrice

Note that "renewal" in double quotes is a case insensitive search, so will exclude both "renewal" and "Renewal". 

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[JamesR]

Sum({StageName={'Closed Won'}, Opportunity.Name-={"renewal"}>}TotalPrice)

still throws error of expected }, and I can't figure out where

[rwunderlich · Accepted solution]

We both forgot a <

Sum({<StageName={'Closed Won'}, Opportunity.Name-={"renewal"}>}TotalPrice

-Rob