Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

mark_cohen684
New Contributor

Help with a measure expression

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

1 Solution

Accepted Solutions

Re: Help with a measure expression

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)

2 Replies

Re: Help with a measure expression

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)

mark_cohen684
New Contributor

Re: Help with a measure expression

Thanks Sunny.  That works perfectly. 

Community Browser