topic Re: pivot table issue in QlikView

pivot table issue

Thu, 11 Dec 2014 12:11:10 GMT

Here in this pivot table i wrote the expression for the Final Performance is like

=if(Dimensionality()>1,

[Coperate SLP]*Performance,

)

i want the total at the bottom as Sum (Final Performance) AS 109+0 =109.

Re: pivot table issue

Colin-Albert — Thu, 11 Dec 2014 12:14:11 GMT

What value do you get on the Total row if you just enable partial sums on the presentation tab for the top level dimension, without including a test on Dimensionality() ?

Re: pivot table issue

Thu, 11 Dec 2014 12:18:41 GMT

it is displaying '0' At total .

with this Expression at final performance , then how can i get total ,

=if(Dimensionality()>1,

[Coperate SLP]*Performance,

)

Re: pivot table issue

Thu, 11 Dec 2014 12:18:53 GMT

Think your colleague got in there first with this question

http://community.qlik.com/thread/145225

might want to close and focus efforts just on one thread