Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Qlik Sense - Pivot Table Extension

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik Sense - Pivot Table Extension

Attachments

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

Comments
mdmukramali
Specialist III
Specialist III

good feature end User can make the layout changes

Thanks,

Mukram

0 Likes
Not applicable

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
Partner - Master II
Partner - Master II

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

0 Likes
Not applicable

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.

Not applicable

Thanks Juan..

0 Likes
Not applicable

Works Great Juan! Thank you for sharing!

0 Likes
Not applicable

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.


0 Likes
Not applicable

Hi Juan

Any news on the sort issue ?

0 Likes
Not applicable

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

i will keep you informed if any progress.

Not applicable

Thanks Juan

0 Likes
Version history
Last update:
‎2014-09-04 07:33 PM
Updated by: