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

[qlikhalmar]

Hi Juan,

Great extension!

Is it possible to put all the fields by default at the top (an empty table)?

Why can we add not more than one measure?

Thanks!

[#3]

hey, a little confused here..

i don't understand what is the aggregation part if we are already using aggregation functions in the measure?

the results in the cells comes out wrong for me

what am i missing?

[#4]

Hi all,

     To answer some of the questions you are writing here:

• I will do no more versions to this extension as I suposse sometime in the future will appear any pivot extension from Qlik better than this, so I prefer to spend my time in any other "good ideas" I have in mind with Qlik Sense.
• Some limitations (aggregations, totals, precision, etc.) are due to the original JS table libraries I am using as base for my design.
• Anyway, the code is open and you can get it from github and fork it to make any improvements, modifications and fixes you need for the community. I encourage you to do this as the philosophy for this extension is to share and help other Qlik Sense developers.

     I am amazingly happy to see how my extension has helped so many people and the expectation it has created among the community. Thank you for your acknowledgements and gratitudes, really appreciated!

     I also want to encourage you to develop more extensions and mashups with Qlik Sense as these are a very powerful features in the new platform, and a really incredible opportunity for Qlik developers to show their real power. Please, give it a chance, it is worth.

Regards,

   Juan Gerardo

[#5]

Hi.  Im  use this its a great  extension, but i need 2 measures, can u help, this is posible

thaks

[brijesh1991]

Hi Jaun... This is wonderful... just need a partial sum (like we do in Qlikivew at all dimension level). I believe it's not available.. Can you please guide how I can achieve this with this extension.

Thanks

BRIJESH

[#7]

Hi,

Can anyone tell me that how can we remove the decimal points with this extension. Because i haven't found a way to do it yet !!

[megabyte23]

Decimal Fix: There's an issue with this when you change it to use the Number format, it doesn't drop the decimal and trailing zeroes. This is not a clean fix, but you can go into pivot.js and update line 32:

defaults = {

      digitsAfterDecimal: 2,

To

defaults = {

      digitsAfterDecimal: 0,

This doesn't fix the bug, it just forces the code to remove the trailing zeroes as the default state. I'll look at it closer for a more elegant answer and update here if I figure it out. @Ehtesham Nadeem

[cedriclupo]

Hello and thanks for your extension, i'm about to download it and hopefully it will answer my needs!

Could you please tell me if it's possible natively or with code modification to remove a column where all lines = 0?

Thank you

[Anonymous]

Hi,  great extension,  can we set all the null to zero in the pivot table values ?

Thank you !

[drojasromero]

Great Extension!

The only problem is in the export, it doesn´t keep the user selected layout.

There is a way to make this works?

Thank you!!