topic Re: Ignore Dimension in Pivot Table Calculation in QlikView

Ignore Dimension in Pivot Table Calculation

Tue, 23 Oct 2012 14:35:42 GMT

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!

Re: Ignore Dimension in Pivot Table Calculation

Tue, 23 Oct 2012 15:23:15 GMT

can u post some sample data ?

Re: Ignore Dimension in Pivot Table Calculation

Tue, 23 Oct 2012 15:49:57 GMT

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.

Re: Ignore Dimension in Pivot Table Calculation

Tue, 23 Oct 2012 15:50:12 GMT

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

Re: Ignore Dimension in Pivot Table Calculation

Tue, 23 Oct 2012 15:52:05 GMT

Have your tried something like Sum(TOTAL Members)

Re: Ignore Dimension in Pivot Table Calculation

Tue, 23 Oct 2012 15:52:20 GMT

use sum(total Members)

Re: Ignore Dimension in Pivot Table Calculation

Tue, 23 Oct 2012 15:54:38 GMT

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!

Re: Ignore Dimension in Pivot Table Calculation

Tue, 23 Oct 2012 15:56:06 GMT

Hi,

Did you try with TOTAL ?

ex :

count(TOTAL Member_Id)

sum(TOTAL Member_Field)

Re: Ignore Dimension in Pivot Table Calculation

Tue, 23 Oct 2012 15:56:20 GMT

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

Re: Ignore Dimension in Pivot Table Calculation

Tue, 23 Oct 2012 15:58:24 GMT

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