Qlik Community

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.

dnt frgt to Mark Answered

You just made the question difficult

Regards

Not applicable

Re: Ignore Dimension in Pivot Table Calculation

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

Community Browser