Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ikomlyakov1929
Partner - Contributor III
Partner - Contributor III

getRowCount() method returns wrong result

Hello!

I have an extension that should react different in case of lack of data. So for example i have table with one dimension and one measure.

I ticked the condition NullSuppression for dimension, so I do not want to get null values of dimension.

After that I implement c couple filters to get the situation when I haven't got any data.

BUT when i call method this.backendApi.getRowCount(), it returns me 1 row, and the method this.backendApi.getDataRow(0) returns me the following:


Getrowcount.JPG

All the values are null. Why do QS returns me row count = 1?

Qlik Sense November 2017

2 Replies
ErikWetterberg

Hi,

Your first cell is a dimension, qElemNumber -2 means it is collapsed,(check NxCell definition here) is this a pivot table?? Looks like you get one collapsed cell in an empty pivot table.

Erik

ikomlyakov1929
Partner - Contributor III
Partner - Contributor III
Author

Hi Erik,

I define my HyperCube like this:

initialProperties:{

            version: 1.0,

            qHyperCubeDef: {

                qDimensions: [],

                qMeasures: [],

                qInitialDataFetch: [{

                    qWidth: 50,

                    qHeight: 50

                }]

            }

        }

As I understand, by default qMode is DATA_MODE_STRAIGHT