Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
gpierezan
Contributor
Contributor

Pivot Table Column Titles (why is it still 'flying'?)

It's been a long time since users and devs are asking qlik to change the object pivot tables. it most certainly is the one object that everyone needs on its analitycs app but qlik seems to don't care about its usability and flexibility. As a result, qlik offers one of (if not the most) worse pivot table object of the industry. And seems to be OK with it. 

In one shy movement that may be seen as an attempt to close this gap, the visualization bundle pivot table was released but, it still has some issues that are hard to live with...

As example, I post a print of the same data on the two objects. the upper is the old pivot table, unusable. below is the visualization bundle pivot table with the annoying divisor between dimensions and measures that simply can not be moved to an optimum fit... 

come on qlik. give IA break and fix the basics.

gpierezan_0-1727359978834.png

 

Labels (1)
4 Replies
Rohan
Specialist
Specialist

Hi @gpierezan ,

I can see that you are having a lot of dimension columns in your pivot. Generally speaking, A pivot should at max be having 4/5 columns as dimensions. Instead of improving the pivot, maybe if Qlik provides the Cell merging functionality in a straight table then maybe that would be helpful in cases where the no of dimensions are more than 5.

 

Regards,

Rohan.

Or
MVP
MVP

[quote] Generally speaking, A pivot should at max be having 4/5 columns as dimensions. [/quote]

Completely disagree...

 

I'd also love to see improvements to the pivot table. I've been using third-party extensions for years because Qlik can't provide a good one.

gpierezan
Contributor
Contributor
Author

Hi. 

Can you inform me how to use this third-party extension?

to be honest I have no expectations that qlik will change anything on this object.... they're too busy trying to implement a ton of no-use tools and resources and have forgotten about the basics...

Or
MVP
MVP

Personally, I think the new pivot table looks like a step in the right direction (as is the new Table object) - the first part of dealing with a problem is acknowledging the problem, and Qlik seems to have done that with their table objects. That said, there is still some way to go.

My preferred option for pivots and tables is Vizlib Library (which I also use for several other object types), but that's just my own personal preference - you should probably do your own research before you pick something.