Qlik Sense - Pivot Table Extension

[#1]

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.

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

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:

Enjoy,

Juan Gerardo

[simon_ball]

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.

[venkatg6759]

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

[isingh30]

Awesome

Thanks

[Anonymous]

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

[mayuringale25]

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

any solution

[mayuringale25]

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

any solution

[howiekrauth]

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

[mayuringale25]

Yes @howiekrauth  issue is solved

[Madhab77]

Can we have multiple measures? Currently having one measure.

[mayuringale25]

Hii @Madhab77 

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