Documents for Qlik Sense related information.
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:
good feature end User can make the layout changes
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.
Agree with Graeme this is excellent except for the Sorting bug. Look forward to seeing a fix to it soon.
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.
Works Great Juan! Thank you for sharing!
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.
Any news on the sort issue ?
Hi Graeme, I have started, but I have not much time at this moment.
i will keep you informed if any progress.