Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How get the sum of an expression in a pivot table

Hi,

I am working on the following pivot table where I have multiple number of dimensions and expressions..

Then I select to show Partial Sums for my desired dimension, The table shows sums for all existing expressions (See image)

How can I set this up to show only the totals the expressions I want?

capture.jpg

Thanks,

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

You add Column expression Dimensionality() and You see the value of Dimensionality for each row.

and you write the expression in base of this value.

If the value of dimensionality for row TOTAL is 0 you write if(Dimensionality() <> 0,sum(a),' ') or if value is 1

you write if(Dimensionality() <> 1,sum(A),' ').

Regards,

Antonio

View solution in original post

23 Replies
Not applicable
Author

Hi,

use set analysis

Anonymous
Not applicable
Author

go to presentation tab and uncheck the parital sum (for fields you feel not necessary)

hope it helps

Sri1

Not applicable
Author

I did before. I only have the first dimension checked for showing partial sums.

My table shows the totals of all expressions as highlighted in the screen shot.

Not applicable
Author

Hi, Do you have an example you could share? I am pretty new to QlikView.

Thanks,

ger_alegria
Partner - Creator
Partner - Creator

In a pivot table you can not show sum of rows in total expresion. You must to use set analysis for adjust the expression to show you wish.

Not applicable
Author

Yeah I only need two of my expressions to show the totals...

Started to read about the set analysis but I am not sure I will be able to understand and implement it by tomorrow. It would be very helpful seeing an example of such implementation.

Help needed desperately

Not applicable
Author

Hi, Do you have an example of such implementation? I am new to QlikView and have very limited time to learn the set analysis and implement it on my table.

Not applicable
Author

Yeah I only need two of my expressions to show the totals...

Started to read about the set analysis but I am not sure I will be able to understand and implement it by tomorrow. It would be very helpful seeing an example of such implementation.

Help needed desperately

ger_alegria
Partner - Creator
Partner - Creator

Can you show me the expression you are using?


And, in what case you obtain a result different you want?