# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

## 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!

1 Solution

Accepted Solutions
Not applicable

## Re: Ignore Dimension in Pivot Table Calculation

Have your tried something like Sum(TOTAL Members)

9 Replies
Not applicable

## Re: Ignore Dimension in Pivot Table Calculation

can u post some sample data ?

Not applicable

## Re: Ignore Dimension in Pivot Table Calculation

Here is what is happening:

Claim Code          Members

001                      10

002                      20

003                      15

004                      10

Total                     55

Here is what I want it to show:

Claim Code          Members

001                      55

002                      55

003                      55

004                      55

Total                    55

I don't want QV to divide membership up by Claim Code (again, claims info is on one table and my membership info is on another).  I need to show some % of total calculations on each line so that is why I need membership in total.

Not applicable

## Re: Ignore Dimension in Pivot Table Calculation

Here is what is happening:

Claim Code          Members

001                      10

002                      20

003                      15

004                      10

Total                     55

Here is what I want it to show:

Claim Code          Members

001                      55

002                      55

003                      55

004                      55

Total                    55

I don't want QV to divide membership up by Claim Code (again, claims info is on one table and my membership info is on another).  I need to show some % of total calculations on each line so that is why I need membership in total.

Not applicable

## Re: Ignore Dimension in Pivot Table Calculation

Have your tried something like Sum(TOTAL Members)

Not applicable

## Re: Ignore Dimension in Pivot Table Calculation

use sum(total Members)

Not applicable

## Re: Ignore Dimension in Pivot Table Calculation

Thanks.  This worked.  I thought I already tried a sum total but I guess not.

I am new to QV so forgive me for the easy question!

Not applicable

## Re: Ignore Dimension in Pivot Table Calculation

Hi,

Did you try with TOTAL ?

ex :

count(TOTAL Member_Id)

or

sum(TOTAL Member_Field)

Not applicable

## Re: Ignore Dimension in Pivot Table Calculation

Hi,

there is no silly question. So dnt be sorry. we'all are learning here.