2 Replies Latest reply: Feb 18, 2016 4:51 PM by Mark Cohen RSS

    Help with a measure expression

    Mark Cohen

      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