Qlik Community

Qlik Sense Documents

Qlik Sense documentation and resources.

Qlik Sense - Pivot Table Extension

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik Sense - Pivot Table Extension

Attachments

Here I am sharing my last extension for QlikSense: JSPivotTable.

This extension is built using Nicolas Kruchten’s pivot table found here.


I have integrated into QlikSense to work in two different modes, dynamic and static:


     Static mode: The fields and their positions are selected in edit mode, and it is not possible to change it when in visualization mode.

Capture.PNG.png

     Dynamic mode: It allows the user to change the initial layout of rows and columns in visualization mode:

Capture.PNG.png

Instructions:

  1. Unzip the JSPivotTable.zip contents into your C:\Users\<user name>\Documents\Qlik\Sense\Extensions\ directory (where <user name> is your personal user name on Windows)
  2. Open Qlik Sense and create a new visualization app or edit an existing one.
  3. Edit a sheet to include the JSPivotTable object which should now be available in your list of chart types.
  4. When in edit mode, in the Appearance tab you have a group of properties called Pivot Table where you can customize the object:

Capture.PNG.png

Enjoy,

Juan Gerardo

Comments
simon_ball
Contributor II
Contributor II

Hello.

I was working on a pivot from qlikview to qliksense and discovered the sense issue of putting the totals columns on the left and row totals at the top...researched and found your extension and installed it, but it only allows me to select 1 measure...I notice the source Jquery table allows multiple measures...would it be possible to amend this code to allow Measures?  If so how would you go about it?  I've used JS a little about 4 years ago but don;t know where to start in your extensions.

0 Likes
venkatg6759
Creator III
Creator III

This is great extension . Is it possible to add multiple measures to this ? Currently it allows only one measure.

0 Likes
isingh30
Specialist
Specialist

Awesome

Thanks

0 Likes
eltonaguiar
Contributor III
Contributor III

Great extension except for the sorting bug as mentioned, sorting doesn't seem to work in this extension, but in the default pivots in QlikSense it works fine.

nice crisp pivot

0 Likes
mayuringale25
Partner
Partner

I have increase the dimension size to 11  but in qMatrix its only showing data for 10 array only..??

any solution

0 Likes
mayuringale25
Partner
Partner

I have increase the dimension size to 11  but in qMatrix its only showing data for 10 array only..??

any solution

0 Likes
howiekrauth
Partner
Partner

Sorting still seems to be an issue - is that correct?

0 Likes
mayuringale25
Partner
Partner

Yes @howiekrauth  issue is solved

0 Likes
Madhab77
Contributor III
Contributor III

Can we have multiple measures? Currently having one measure.

0 Likes
mayuringale25
Partner
Partner

Hii @Madhab77 

Yes we can have multiple measure but for that you have to change code.And its very complicated to do.

0 Likes
Version history
Last update:
‎2014-09-04 07:33 PM
Updated by: