Qlik Sense - Pivot Table Extension

    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:




    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:





    Juan Gerardo