4 Replies Latest reply: Dec 5, 2017 9:45 PM by Luis Madriz RSS

    Dimension expression using multiple conditions

    Michelle Sparke

      I have my QlikSense linked to an ODBC database.  The tables have history information in many fields. I need to set up a dimension that will only count based on conditions.

       

      An example is a Dimension called "ActiveEngagement".  This will have the following conditions:

      VariationActive = 1

      CurrentRecord = 1

      VariationStatus != Separated

      VariationReason != Separation

       

      How do I put this into an expression?

       

      Thank you