Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

Have your tried something like Sum(TOTAL Members)

View solution in original post

9 Replies
Not applicable
Author

can u post some sample data ?

Not applicable
Author

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
Author

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
Author

Have your tried something like Sum(TOTAL Members)

Not applicable
Author

use sum(total Members)

Not applicable
Author

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
Author

Hi,

Did you try with TOTAL ?

ex :

count(TOTAL Member_Id)

or

sum(TOTAL Member_Field)

Not applicable
Author

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

Not applicable
Author

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