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

[mdmukramali]

good feature end User can make the layout changes

Thanks,

Mukram

[#3]

This is brilliant, and it almost does what I need - the sort order however, when sorting on multiple dimensions, doesn't seem to change anything.

I've tried alphabetical, numerical, and also by expression, but it always seems to default to Ascending for both - I need Descending.

Aside from that - this is perfect and should be in Sense by default.

[ogster1974]

Agree with Graeme this is excellent except for the Sorting bug.  Look forward to seeing a fix to it soon.

[#5]

Hi Graeme,

     Thank you for the feedback. Yes, I have also noticed this behaviour. This pivot table has its own order criteria, and I will investigate if there is any way to map the sorting properties in QlikSense with the ones in the extension. If not possible, I will remove the Sorting tab from the properties to avoid confusion.

     I will keep you posted.

[#6]

Thanks Juan..

[#7]

Works Great Juan! Thank you for sharing!

[#8]

Thanks Juan for this very helpfull extension for pivot tables.

I didn't found a way to define colors and ranges for heatmaps. 

I hope we'll have this possibility in next versions.

[#9]

Hi Juan

Any news on the sort issue ?

[#10]

Hi Graeme, I have started, but I have not much time at this moment.

i will keep you informed if any progress.

[#11]

Thanks Juan