Ignore Dimension in Pivot Table Calculation

[#1]

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!

[#2]

can u post some sample data ?

[#3]

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.

[#4]

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.

[#5 · Accepted solution]

Have your tried something like Sum(TOTAL Members)

[#6]

use sum(total Members)

[#7]

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!

[#8]

Hi,

Did you try with TOTAL ?

ex :

count(TOTAL Member_Id)

or

sum(TOTAL Member_Field)

[#9]

Hi,

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

dnt frgt to Mark Answered

You just made the question difficult

Regards

[#10]

Thanks everyone.  All of these answers were correct.  I marked correct answer for Nigel's response.  Appreciate the quick feedback.