Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mike_garcia
Specialist
Specialist

Inconsistency in Pivot Table

One of my applications is presenting an inconsistency with a Pivot Table. I have a field, called 'Month', which is associated with the field 'Quarter' and is used as a Dimension in the chart . This field is placed in a List Box for selections.

When I select a Year (2009, for example), the Pivot Table shows a Number for every Month. It looks like this:

error loading image

Then, when I actually make a Selection for the Qaurter (Q1, for example) obviously the chart is reduced to show only the associated months, but the numbers change, as you can see in this image:

error loading image

Any ideas why this might be happening and how can I fix it?

Any help is greatly appreciated. Regards,

Mike.

Miguel García
Qlik Expert, Author and Trainer
1 Reply
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Mike,

It would be easier to trouble shoot if you could post an example (perhaps a subset of your data or scrambled data...)

As a suggestion - add Quarter as a Dimension to your Pivot table and see what happens.

cheers,