Qlik Community

Qlik Sense Integration, Extensions, & APIs

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

Not applicable

extension - prevent calculation of qGrandTotalRow totals

Hi,

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 {

        values_to_select:[],

        swipe_row_min: -1,

        swipe_row_max: -1,

        qHyperCubeDef: {

            qDimensions: [],

            qMeasures: [],

            qInitialDataFetch: [

                {

                    qWidth: 6,

                    qHeight: 20

                }

            ]

        }

    };

} );

Will highly appreciate any help,

KS

Tags (2)
1 Reply
Not applicable

Re: extension - prevent calculation of qGrandTotalRow totals

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

Community Browser