Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
sunny_talwar

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
sunny_talwar

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
Not applicable
Author

Thanks Sunny.  That works perfectly.