Qlik Sense - Pivot Table Extension

Move Document

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:

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)
Open Qlik Sense and create a new visualization app or edit an existing one.
Edit a sheet to include the JSPivotTable object which should now be available in your list of chart types.
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

venkatg6759 · ‎2018-04-12

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

isingh30 · ‎2018-05-15

Awesome

Thanks

Anonymous · ‎2018-05-26

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 · ‎2019-05-02

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

any solution

mayuringale25 · ‎2019-05-02

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

any solution

howiekrauth · ‎2019-07-26

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

mayuringale25 · ‎2019-08-17

Yes @howiekrauth issue is solved

Madhab77 · ‎2019-09-04

Can we have multiple measures? Currently having one measure.

mayuringale25 · ‎2019-09-09

Hii @Madhab77

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

ellieM · ‎2020-03-18

you mentioned that Sorting issue is solved. but still doesn't work for me. I need to sort based on Months. how can i do that?