Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
dmohanty
Partner - Specialist
Partner - Specialist

Behaviour of Pivot Table?

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.

Pivot.jpg

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

PResent.jpg

2 Replies
avinashelite

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.

SunilChauhan
Champion II
Champion II

check weither selection is excluded in pivot table like below example

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

or

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

or

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

{1} also excludes selection

Sunil Chauhan