Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
markodonovan
Specialist
Specialist

Love the Qlik Sense Pivot table but would love more

Hi all,

What does everyone think of the Qlik Sense pivot table?

Really glad to see it included in Qlik Sense now but there are a few things I would like as well.

Let me know what you think:

1. Ability to make on selections or expand the row.

2. Export to Excel (I know the ideal is to do everything is to work within Qlik Sense).

3. Ability to disable rows\columns rather than delete them and also do this from analysis mode.

What do you think?

Mark

www.youtube.com/practicalqlik

www.amazon.com/Mark-ODonovan/e/B007QUFRQY

1 Solution

Accepted Solutions
Patrik_Lundblad
Employee
Employee

Hi Mark,

I'm really happy about the feedback and good that you enjoyed seeing it now part of our Qlik Sense product

Those 3 features are on our todo list together with some more funtionality. But if everyone could add what they want to see in an interactive pivot table it would be nice for us to make sure we capture all user requirements.

Regards,

Patrik

View solution in original post

11 Replies
Patrik_Lundblad
Employee
Employee

Hi Mark,

I'm really happy about the feedback and good that you enjoyed seeing it now part of our Qlik Sense product

Those 3 features are on our todo list together with some more funtionality. But if everyone could add what they want to see in an interactive pivot table it would be nice for us to make sure we capture all user requirements.

Regards,

Patrik

Not applicable

This is both suggestions for the PivotTable and the StraightTable

  1. Column width and height
  2. Inline graphs
  3. Show dimension as image
  4. Icons
markodonovan
Specialist
Specialist
Author

Hi Patrik,

That's great news.

Thanks for the response.

Mark

Anonymous
Not applicable

I also love that Pivot Table has been added to Qlik Sense, but on the list of things that should be added, we should be able to add subtotals at whichever level(s) we require.  It seems that right now we are locked into totals only on the primary dimension (or not at all).

Anonymous
Not applicable

Another suggestion would be to have totals for each column (not just sub-totals for each row). Thanks!

shanemichelon
Partner - Creator II
Partner - Creator II

I think I have found a bug/oversight.  When you add a column group, and select a limitation (say top 5), it won't show anything except others unless you expand the first dimensions.

To replicate:

Create three dimensions, Year, Month and Stock Group (or whatever).  Add a single measure (say Sum(Amount)).

Move the last dimension down to columns, and set the limitation to fixed number.  I'm using 5 as my example.

Now the chart only shows Others, until you expand one of the years:

Qliksense sample1.png

Qliksense sample2.png

Patrik_Lundblad
Employee
Employee

Hi Shane,

We've verified it as a bug and it was fixed internally yesterday and will be part of the next release.

Thanks for reporting it!

Regards,

Patrik

Not applicable

Ty all,

Also if it is possible to disdide in wich side the pivot direction-

right to left or left to right

altough its no in qlik view

Anonymous
Not applicable

Adding my 2 cents - and I apologize in advance for some repeats:

  1. Export to Excel, while already mentioned, is a high priority for us.
  2. Sort  by clicking any row header
  3. Adjust column widths (even allowing us to give a % of screen size per column would help)
  4. Fix export to PDF (which is currently just a screen shot)