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:
- 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: