Solved: Re: How get the sum of an expression in a pivot ta... - Qlik Community

Report Inappropriate Content · ‎2014-04-10

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?

Thanks,

antoniotiman · ‎2014-04-10

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

Report Inappropriate Content · ‎2014-04-10

Hi,

use set analysis

Anonymous · ‎2014-04-10

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

hope it helps

Sri1

Report Inappropriate Content · ‎2014-04-10

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.

Report Inappropriate Content · ‎2014-04-10

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

Thanks,

ger_alegria · ‎2014-04-10

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.

Report Inappropriate Content · ‎2014-04-10

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

Report Inappropriate Content · ‎2014-04-10

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.

Report Inappropriate Content · ‎2014-04-10

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 · ‎2014-04-10

Can you show me the expression you are using?

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

How get the sum of an expression in a pivot table