topic Re: Help with a measure expression in App Development

Help with a measure expression

Anonymous — Thu, 18 Feb 2016 21:08:16 GMT

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

Re: Help with a measure expression

sunny_talwar — Thu, 18 Feb 2016 21:46:46 GMT

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)

Re: Help with a measure expression

Anonymous — Thu, 18 Feb 2016 21:51:12 GMT

Thanks Sunny. That works perfectly.