Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Read about the latest Qlik Community enhancements on the Community News blog!
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Extension for pivot table


I´m using enterprise edition.

I´m Trying to create a extension to change the css layout of pivot table. The problem is that the table look like a straight in spite of looking like a pivot table:


But I want it to look like this (using aggregations):



I have seen the JS Pivottable and others but the code is too much modified and return errors. I just one the core function of the pivot table and change only the CSS.

paint: function ( $element, layout ) {

var html = "<table><thead><tr>", self = this,

morebutton = false,

hypercube = layout.qHyperCube,

rowcount = hypercube.qDataPages[0].qMatrix.length,

colcount = hypercube.qDimensionInfo.length + hypercube.qMeasureInfo.length;

hypercube.qMode = 'P';

//render titles

hypercube.qDimensionInfo.forEach( function ( cell ) {

html += '<th>' + cell.qFallbackTitle + '</th>';

} );

hypercube.qMeasureInfo.forEach( function ( cell ) {

html += '<th>' + cell.qFallbackTitle + '</th>';

} );

html += "</tr></thead><tbody>";

//render data

html += createRows( hypercube.qDataPages[0].qMatrix, hypercube.qDimensionInfo );

html += "</tbody></table>";

//add 'more...' button

if ( hypercube.qSize.qcy > rowcount ) {

html += "<button class='more'>Mais...</button>";

morebutton = true;


$element.html( html );



0 Replies