idea Re: Pivot Table - Total Option (Above & Below) in Suggest an Idea

Pivot Table - Total Option (Above & Below)

Silambarasan1306 — Wed, 25 Nov 2020 15:12:24 GMT

Hi Techies, There are lot of updates in the qlik sense server (i.e. Charts, Data management, etc.,). But, I really felt very bad about the PIVOT TABLE. Every clients needs pivot table total to be placed below the rows. Why don't we have any changes in the pivot table row total (Above & Below option) and for column totals (Right & Left).. ?? This will be a great advantage if we have this option too.. 🙂 Thanks.

Re: Pivot Table - Total Option (Above & Below)

Anonymous — Fri, 23 Aug 2019 08:24:56 GMT

Hello,

To be fair, the Pivot Table need a total redesign :

-placement of total

-more flexibility to develop (develop column by column or develop several columns at once)

-proper displaying of column header

-etc, etc...

Re: Pivot Table - Total Option (Above & Below) - Status changed to: Open - Collecting Feedback

Patric_Nordstrom — Tue, 21 Apr 2020 16:03:07 GMT

Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

Thanks,

Patric

Re: Pivot Table - Total Option (Above & Below)

aldo-tgh — Mon, 15 Jun 2020 13:54:44 GMT

Will be useful to have the option to let the user to decide if to show / hide totals per dimension.

Re: Pivot Table - Total Option (Above & Below)

Carl_Hunter — Fri, 26 Jun 2020 12:47:11 GMT

This is very much needed, SIMPLY having the Totals on the right, rather than the left in a Pivot table is super simple yet powerful.

Re: Pivot Table - Total Option (Above & Below)

adamjank — Thu, 25 Feb 2021 20:11:19 GMT

'2019-08-21" @Patric_Nordstrom
It's over 1.5y and still we can't make totals on the bottom...
It's not funny

Re: Pivot Table - Total Option (Above & Below)

rodjager — Tue, 06 Apr 2021 07:20:49 GMT

From my (partner) perspective, as we look for ways to help clients make the migration from QlikView to Qlik Sense, this is a functionality gap that keeps arising. Some time back, there was an indication that advanced authoring was a priority and I would like to think this qualifies.

This function gap comes up regularly for financial reporting and while the P&L Pivot extension goes some way to closing this gap, it would be beneficial to have this type of control over the standard pivot table as there are times when the P&L Pivot isn't suitable i.e. reporting with multi-level chart of accounts.

As a workaround we can publish a QlikView app in the Qlik Sense hub, however, that doesn't offer the opportunity to really use all of the benefits that Qlik Sense can offer, nor does it really assist new sites.

I appreciate the opportunity to provide Qlik with this level of feedback and I know there are a lot of competing priorities, however, it would be great to understand where this fits on the product roadmap.

Thanks.

Re: Pivot Table - Total Option (Above & Below)

GMS1 — Thu, 03 Nov 2022 21:54:53 GMT

Hi,

is there any further progress to this issue?

I find it quite crazy that a market leading platform cannot have this simple feature.

Re: Pivot Table - Total Option (Above & Below)

CindyGoutier123 — Mon, 14 Nov 2022 23:49:29 GMT

Hi,

I would like to reiterate the importance of this requirement please. We have a large userbase and this requirement keeps coming up time and time again.

Can we please get some support in getting this added to the product.

Many thanks

Re: Pivot Table - Total Option (Above & Below)

GMS1 — Wed, 16 Nov 2022 02:38:09 GMT

Hi Qlik,

Could we get an update as to if this will be considered or has been considered to be implemented?

Current status is open - 'collecting feedback', is there enough feedback here to implement this?

Over 1,000 views and 3 years.

Re: Pivot Table - Total Option (Above & Below)

Helmut — Wed, 16 Nov 2022 08:03:15 GMT

Hi Qlik,

please add those feature and extend the capability for the pivot table.

Re: Pivot Table - Total Option (Above & Below)

adamjank — Wed, 16 Nov 2022 08:55:23 GMT

After 3 (THREE!!) years there's still no option to choose it
To have it you have to do workaround through the calculated dimensions or buy the VizLib extensions

Also, there's a third option - use the PowerBI and check if it matches most of the same needs that you got
I've sent them couple of tweaks and ALL of them have been implemented - please check their monthly updates

I've been a promoter of the Qlik products for years - but after leaving the QlikView by Qlik I cannot agree that QS > PBI...

QS got only couple tweaks for 2-4 years, when PBI has been changed dramatically

Re: Pivot Table - Total Option (Above & Below)

Meghann_MacDonald — Wed, 07 Dec 2022 18:48:58 GMT

Also requested here: https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Sense-Pivottable-Position-of-Total-Value/idi-p/1820335

Re: Pivot Table - Total Option (Above & Below)

GMS1 — Wed, 07 Dec 2022 20:52:00 GMT

Hi @Meghann_MacDonald

How can we get more support for this idea?

Obviously, this thread and the comments and likes, but I am thinking a lot of these ideas get lost in the multitude of ideas.

There are likely a lot of 'quality of life' ideas in the same boat that although they may seem small to some, would be absolutely welcome if implemented.

this being one of them.

Re: Pivot Table - Total Option (Above & Below)

harsh_patel-dis — Mon, 16 Jan 2023 18:38:21 GMT

+1 for this idea.

Just as the others have mentioned here, it's amazing that this idea has not been implemented yet. We have so many clients moving from QV to QS (and now SaaS), but every single migration i've come across, the pivot table is always the sticking point. Qlik Sense pivot table is simply not very good and lack of this simple functionality doesn't help. We have to go through so many hoops and workarounds to make a simple thing work.

Hoping to add more visibility to this idea and a general improvement of pivot tables in qlik sense. It's long overdue.

Re: Pivot Table - Total Option (Above & Below)

RadovanOresky — Wed, 18 Jan 2023 10:23:35 GMT

Would be also useful:

possibility to adjust width of measures / columns (like in straight table)
possibility to expand or collaps just next level (only ALL is currently available which can create quite a mess with more than 4 dimensions)
option to fit columns to data - when the object is placed on the whole page but the pivot is collapsed to highest level with just one measure, then dimension text is on the left and measure value is on far right, which makes the whole thing unreadable
option to set the line height of a row

Partner view - definitely a real blocker of migration from QlikView to Sense.

MAKE PIVOT TABLE GREAT AGAIN! 😉

Re: Pivot Table - Total Option (Above & Below) - Status changed to: Open - On Roadmap

Patric_Nordstrom — Fri, 20 Jan 2023 13:48:40 GMT

Re: Pivot Table - Total Option (Above & Below)

AnalyticsDev — Fri, 20 Jan 2023 20:30:04 GMT

Add me to the list of wanting this. This will probably be another instance where I head back to my CIO and say "Yah, this isn't available in Qliksense but was likely an easy function in Qlikview'.

Re: Pivot Table - Total Option (Above & Below)

ilanbaruch — Tue, 14 Feb 2023 09:22:16 GMT

hi @Patric_Nordstrom

can you please give aprox. time to deliver?

Re: Pivot Table - Total Option (Above & Below)

Patric_Nordstrom — Mon, 20 Feb 2023 09:24:41 GMT

The new pivot is probably coming after summer, and hopefully we can tick off a number of requests for new functionality.