Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Extension : The calculation page is too large

Hi all,

I'm creating a new line chart with time as the X-Axis ,, it was working properly ,, I restarted my laptop ,, and opened qlik sense again tried to use it and all I get is this message

The calculation page is too large. Reduce the number of cells and try again .

I also have a problem ,, that qlik sense retrieves only the numbers of the first 2 measures ,,

so I add 1 dimension 4 measures ,, and I get a hyper cube with only 3 elements width [1 dimension , 2 measures]

why could this happen ?

Regards

14 Replies
rbecher
MVP
MVP

Don't really understand the problem. Can you upload your extension example and the app to get this fixed..

Btw. if you change the extension definition you have to delete the extension from sheet and drag it in again. Also, be sure you have disabled browser cache in chrome developer tools.

Astrato.io Head of R&D
Not applicable
Author

I restarted the qlik sense app, removed the chart and added it again ,, and now it works ,,

Thx for your help Mr.Ralf

I'll mark your answer as the correct one

Anonymous
Not applicable
Author

Hi Ralf,

I am trying to understand how to build a custom extension.

I loaded some dummy data. There are 5 columns and 9864 rows.

sense custom extension data model.png

I took this extension script, nothing special (I plan to use d3, hence references):

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
define( ["./js/d3.min", "./js/senseD3utils", "./js/senseUtils"],
    function ( ) {
        'use strict';
        return {
            definition: {
                type: "items",
                component: "accordion",
                items: {
                    dimensions: {
                        uses: "dimensions"                    },
                    measures: {
                        uses: "measures"                    }
                }
            },
            initialProperties: {
                qHyperCubeDef: {
                    qDimensions: [],
                    qMeasures: [],
                         qInitialDataFetch: [{
                              qWidth: 6,
                              qHeight: 1500                         }]
                }
            },
            paint: function ( $element, layout ) {
                var hc = layout.qHyperCube;
                console.clear();
                    console.log( 'Data returned: ', hc );
            }
        };
    } );

The extension was created, and I dropped it in the page.

Then I put

  • Dimension: [CC]
  • Measure sum(Actual)

And get the same "the calculation page is too large".

What am I missing? Also, is there a way not to anticipate the number of dimensions and measures (because above you say: ok, if there are 2 dimensions and 1 measure, you need to put 3 as Width <-- why should we hardcode this???)

If you have a tutorial (or documentation) explaining this calculation page, I would be glad if you can share it. In no existing tutorials could I find an explanation for this "calculation page" behavior.

Sense version 3.1 SR3

rbecher
MVP
MVP

Hi Igor,

I think you missed the closing array bracket in qInitialDataFetch: [ { } ]

If you expect more dimensions you should set qWitdth to the highest expected value for initial data fetch:

qWidth: 20

qHeight: 500

Then, use paging to get all values in paint.

- Ralf

Astrato.io Head of R&D
rbecher
MVP
MVP

Also another closing curly bracket..

Astrato.io Head of R&D