Qlik Community

Qlik Sense App Development

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

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
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
Highlighted

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)

View solution in original post

2 Replies
Highlighted

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)

View solution in original post

mark_cohen684
New Contributor

Re: Help with a measure expression

Thanks Sunny.  That works perfectly.