5 Replies Latest reply: Apr 25, 2017 5:48 AM by Manideep Hv RSS

    How to calculate a Expression based on a value of another expression which matches a selected value

    Nitya Reddy

      Hi,

       

      I am trying to calcualt an expression based on a value of another expression that meets a selected criteria in QlikView. But unablet to figure out:

       

         

      Benchmark StateNY
      StateCustCountSalesExpected SalesAverages
      CA1002001351.45
      NY2002502701.35
      NJ3003004051.23
      TX150400202.52
      WA250350337.51.87

       

       

      I need to calculate Expected Sales based on the average of the Benchmark State selected. In this example the Benchmark State is NY. So all states should use the Average of 1.35 to calculate the Expected Sales. The formula  for Expected Sales is Average * CustCount.