9 Replies Latest reply: Oct 23, 2012 11:58 AM by cjcamp22 RSS

    Ignore Dimension in Pivot Table Calculation

      Hello QV Community,

       

      I am having a problem with QV cooperating the way I want in a pivot table I am building.  I am doing some analysis with Medical Claims utilization for a particular group of members and want to show some metrics for particular utilization types.  For many of my calculations, I need to use the total members as the denominator but QlikView is just showing the sum of the members that had a claim of that particular type.  My member counts are listed on a separate table than my claims table.

       

      Does anyone have any suggestions to correct this?  I essentially need QV to ignore the utilization type when totaling membership in this pivot table (thus making the value a constant for each row).

       

      Thanks for any help anyone can provide!