Skip to main content

Integration, Extension & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

extension - prevent calculation of qGrandTotalRow totals


is that possible to prevent Qlik Sense from calculating grand totals on measures while fetching data?

Even when qInitialDataFetch is limited to a very small number of cells, the engine still calculates the total (qGrandTotalRow).

In our case we have a text field measure in extension and we don't need any calculation of totals. We use Concat as a source aggregation function and it works pretty well.

But calculating of total row takes a huge amount of time and especially painful for network bandwidth to pass a huge total string (more than 30Mb!) We found those qBrutalSum and qAggrFunc properties which could help in theory. But it is not clear how to use them.

This is how we set Initial properties:

/*global define*/

define( [], function () {

    'use strict';

    return {


        swipe_row_min: -1,

        swipe_row_max: -1,

        qHyperCubeDef: {

            qDimensions: [],

            qMeasures: [],

            qInitialDataFetch: [


                    qWidth: 6,

                    qHeight: 20





} );

Will highly appreciate any help,


1 Reply
Not applicable

Still looking for any help on that... Thanks!