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.

    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