article Qlik Sense - Pivot Table Extension in Qlik Sense Documents

Qlik Sense - Pivot Table Extension

Thu, 04 Sep 2014 23:33:24 GMT

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:

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)
Open Qlik Sense and create a new visualization app or edit an existing one.
Edit a sheet to include the JSPivotTable object which should now be available in your list of chart types.
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

Re: Qlik Sense - Pivot Table Extension

mdmukramali — Sun, 07 Sep 2014 12:19:03 GMT

good feature end User can make the layout changes

Thanks,

Mukram

Re: Qlik Sense - Pivot Table Extension

Mon, 08 Sep 2014 08:02:48 GMT

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.

Re: Qlik Sense - Pivot Table Extension

ogster1974 — Mon, 08 Sep 2014 10:52:07 GMT

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

Re: Qlik Sense - Pivot Table Extension

Tue, 09 Sep 2014 16:35:04 GMT

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.

Re: Qlik Sense - Pivot Table Extension

Wed, 10 Sep 2014 05:44:30 GMT

Thanks Juan..

Re: Qlik Sense - Pivot Table Extension

Wed, 10 Sep 2014 12:02:34 GMT

Works Great Juan! Thank you for sharing!

Re: Qlik Sense - Pivot Table Extension

Fri, 12 Sep 2014 09:24:24 GMT

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.

Re: Qlik Sense - Pivot Table Extension

Thu, 18 Sep 2014 06:21:33 GMT

Hi Juan

Any news on the sort issue ?

Re: Qlik Sense - Pivot Table Extension

Mon, 22 Sep 2014 19:21:13 GMT

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

i will keep you informed if any progress.

Re: Qlik Sense - Pivot Table Extension

Wed, 24 Sep 2014 19:57:03 GMT

Hi Juan,

I tried installing the plugin into my Sense 1.0 desktop on WIn 8, but Sense is not seeing it. I placed the pivottable-master folder into C:\Users\Oleg\Documents\Qlik\Sense\Extensions, restarted the app , but it's not showing the new visualization. Do you ave any suggestions on what I'm doing wrong?

Thanks!

Oleg

Re: Qlik Sense - Pivot Table Extension

Thu, 25 Sep 2014 05:34:40 GMT

It will only appear in Edit mode in the application..

If still not appearing, try deleting the JS files from Extension folder and reinstalling Sense then follow:

To install, copy all files to folder "C:\Users\(your user name)\Documents\Qlik\Sense\Extensions\JSPivotTable".

To use, just drag the "JSPivotTable" object from the object menu on the left in Edit mode.

Re: Qlik Sense - Pivot Table Extension

Sat, 27 Sep 2014 16:09:49 GMT

Thanks, Graeme.

I tried a few times, but it's still not working for me. I was able to successfully install a few other sample extensions into Q.S. like "AngularCharts", "PeopleChart" in the same directory as the Pivot table. JS pivot is the only one that's not showing up. All ther extensions have a different directory structure than the pivot:

every folder contains a file with ".wbl" and ".qext" files, which seems like what Qlik is using to recognize that this is an extension. Neither of these files are present in the pivot install. Do I need to create them myself?? Is there a different installer floating around? Or is that a different type of ext that doesn't need those files?

Thanks,

Oleg

Re: Qlik Sense - Pivot Table Extension

Bjorn_Wedbratt — Mon, 29 Sep 2014 06:50:58 GMT

Hi Oleg,

I think you need to try and download the zip file again, it seems like it got corrupt for you.

I can verify the extension does include all required files and is working fine when I tested it. The following files should be included:

JSPivotTable.js
JSPivotTable.qext
JSPivotTable.png
JSPivotTable.css
wbfolder.wbl
d3.min.js
pivot.js

Re: Qlik Sense - Pivot Table Extension

agigliotti — Mon, 29 Sep 2014 09:28:45 GMT

Is it possible to have both expand all and collapse all functionalities ?

Re: Qlik Sense - Pivot Table Extension

Mon, 29 Sep 2014 10:36:51 GMT

Hi Oleg,

If you send your email address to me (juan.cabeza@qlik.com), I will send the zip file to you.

Regards

Re: Qlik Sense - Pivot Table Extension

Mon, 29 Sep 2014 10:46:34 GMT

Hi Andrea,

These functionalities are not included in the original object, so it would require to modify the "pivot.js" code. At this moment I do not want to modify this code to be able to take advance of any new version of the source D3 pivot table.

Anyway, if any of you with more javascript experience want to create any new version of this pivot table, you have the original extension in Github: https://github.com/jgerardoc/QlikSense-Ext-JSPivotTable

Any help is appreciated

Regards

Re: Qlik Sense - Pivot Table Extension

Anonymous — Mon, 29 Sep 2014 15:34:01 GMT

Really great work, Juan. Once again, the high extensibility of Qlik Sense has been proved.

Regards.

Ce BIAN

Re: Qlik Sense - Pivot Table Extension

Tue, 30 Sep 2014 20:50:24 GMT

Appreciate all the help, Juan!

I re-downloaded from the link in the last post and was finally able to install the plugin. Any idea how that would that work in the Sense Server version? Is it installed on the server similar to how it's done on a desktop? Or is this a desktop-only?

Thanks!

Oleg

Re: Qlik Sense - Pivot Table Extension

Fri, 03 Oct 2014 07:47:55 GMT

Yes Oleg, of course you can install in server. But in server you have to use the Management Console.

Go to Extensions:

Then select Import:

And select the ZIP file with the extension.