Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Employee
Employee

Re: Love the Qlik Sense Pivot table but would love more

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
Highlighted
Employee
Employee

Re: Love the Qlik Sense Pivot table but would love more

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

Highlighted
Not applicable

Re: Love the Qlik Sense Pivot table but would love more

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
Highlighted
Specialist
Specialist

Re: Love the Qlik Sense Pivot table but would love more

Hi Patrik,

That's great news.

Thanks for the response.

Mark

Highlighted
Creator III
Creator III

Re: Love the Qlik Sense Pivot table but would love more

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

Highlighted
Creator
Creator

Re: Love the Qlik Sense Pivot table but would love more

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

Highlighted
Partner
Partner

Re: Love the Qlik Sense Pivot table but would love more

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

Highlighted
Employee
Employee

Re: Love the Qlik Sense Pivot table but would love more

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

Highlighted
Not applicable

Re: Love the Qlik Sense Pivot table but would love more

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

Highlighted
Contributor
Contributor

Re: Love the Qlik Sense Pivot table but would love more

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)