Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Table : Partial Sum and Partial Max Value

Hello,

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

a.

=Sum(EXECUTIONS_DELTA)

and

b.

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

and

c.

=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,

2 Replies
Not applicable
Author

Anybody ?

Not applicable
Author

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