topic Re: Behaviour of Pivot Table? in QlikView

Behaviour of Pivot Table?

dmohanty — Wed, 30 Jul 2014 05:00:24 GMT

Hi All,

I am noticing a strange behaviour of PIvot Table. It is happening for some specific values
For example: BUyer Name: JOHN PRIEST, the selections made are not reflecting in the Pivot Table. Screenshot below.

But for some of the rest Buyer Names, table is getting expanded. Screenshot of the Presentation tab is below as well.Please suggest.

Re: Behaviour of Pivot Table?

avinashelite — Wed, 30 Jul 2014 05:05:17 GMT

Hi,

Can you please post your application, its hard to identify the error from the above details.

We need to check the data model and expressions to identify the problem.

Re: Behaviour of Pivot Table?

SunilChauhan — Wed, 30 Jul 2014 05:29:14 GMT

check weither selection is excluded in pivot table like below example

sum({<Region=>} Sales) here Region selection is excluded

check if you chart is deattached( see in title o chart) if so right click on pivot and attch

sum({1} Sales) here Region selection is excluded

{1} also excludes selection