topic Re: Pivot Table : Partial Sum and Partial Max Value in QlikView

Pivot Table : Partial Sum and Partial Max Value

Sat, 28 Jun 2014 22:53:43 GMT

Hello,

I have a Pivot Table and I have the following expression:

=Sum(EXECUTIONS_DELTA)

and

=Sum(ELAPSED_TIME_DELTA)/if(Sum(EXECUTIONS_DELTA)=0,1,Sum(EXECUTIONS_DELTA))/1000

and

=sum(IOWAIT_DELTA)/if(sum(EXECUTIONS_DELTA)=0,1,sum(EXECUTIONS_DELTA))/1000

These are grouped by Time, "Type of call" and "SQLs_USED in particular call"

Question:

I want partial max value of "a" and partial sum of "b" and partial sum of "c". As of now I get wrong values after I click "show partial values" under presentation tab.

Regards,

Re: Pivot Table : Partial Sum and Partial Max Value

Sun, 29 Jun 2014 23:39:10 GMT

Anybody ?

Re: Pivot Table : Partial Sum and Partial Max Value

Sun, 29 Jun 2014 23:43:59 GMT

can you attach the app if possible? or at least highlight the figures in a screenshot where you think the figures have gone wrong?