Help with a measure expression

[Anonymous]

We have a measure expression in a Qlik Sense app that we want to modify, but don't know the correct syntax.

The current expression is:

Sum({1<Subscription_End_RangeID={6},Account_Subscription_Status_Check={0},Account_Do_not_count_as_new_customer={0},Account_Internal_Demo_Check={0}>}AccountCount)

The above expression counts the number of Accounts with a Subscription End Date in the Subscription_End_RangeID.

We want to amend the expression so that it's result does not include Account records where the field Account_Attrition_Reason_Code equals any of the following string values:

Duplicate Account

Never Went Live

Silver Pro Conversion

Thanks,

Mark

[sunny_talwar · Accepted solution]

May be this:

Sum({1<Subscription_End_RangeID={6}, Account_Subscription_Status_Check={0}, Account_Do_not_count_as_new_customer={0}, Account_Internal_Demo_Check={0}, Account_Attrition_Reason_Code -= {'Duplicate Account', 'Never Went Live', 'Silver Pro Conversion'}>}AccountCount)

[Anonymous]

Thanks Sunny.  That works perfectly.