5 Replies Latest reply: Sep 6, 2016 11:49 AM by Sarah Nguyen RSS

    Calculating averages for different categories

    Sarah Nguyen

      I'm new to QlikSense and need help with 3 calculations:

       

      1. Need to calculate 6 mo average for clinical category
        • Take current month (Jul), skip previous 3 months (Apr-Jun) and use prior 6 monts  (Oct-Mar) to calculate 6month average for CLINICAL
      2. Need to calculate 6 mo average for surgery category
        • Take current month (Jul), skip previous 3 months (Apr-Jun) and use prior 6 monts  (Oct-Mar) to calculate 6month average for SURGERY
      3. Calculate difference between the 6 mo averages (in #1 and #2 above) and the [% of pmt to charges] based on the appropriate category (clinical vs surgery). If diff is less than zero, then it should display zero.

       

      I have highlighted in yellow in image below what I'm trying to get to. Thank you.

       

      community.jpg