Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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
plu
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
plu
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

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

aaroncouran
Creator III
Creator III

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).

mhartono
Creator
Creator

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

shanemichelon
Partner
Partner

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

plu
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

bobgsysop
Contributor
Contributor

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)