topic Re: From Table API in Qlik Sense how to get the Dimension Value or HTML Row in Integration, Extension & APIs

From Table API in Qlik Sense how to get the Dimension Value or HTML Row

subash29 — Tue, 31 Oct 2017 12:47:21 GMT

I tried with this funtion

var table = qlik.table(model);

var colNumber = table.getColByName('cedant_parent_name');

var rowCount = table.rowCount;

var cellvalue= table.row[0].dimensions[0].qText;

Re: From Table API in Qlik Sense how to get the Dimension Value or HTML Row

_jespers_ — Tue, 31 Oct 2017 13:26:47 GMT

You either need to use a listener to be able to fetch the row counts:

var table = qlik.table( this );

var listener = function() {
    var rowCount = table.rowCount;
    var colCount = table.colCount;
    table.OnData.unbind( listener );  //unregister the listener when no longer notification is needed.
};
table.OnData.bind( listener ); //bind the listener

Or you can do it like this:

var rows = table.qHyperCube.qSize.qcy;
var cols = table.qHyperCube.qSize.qcx;

Regarding dimension value, that's depending on how many dimensions you have added and on which row you want to fetch the value.

This is an example on how to loop through all your data:

var data = table.qHyperCube.qDataPages[0].qMatrix;

                $.each(data, function( key, value ) {
                      console.log("value", value);
                });

Re: From Table API in Qlik Sense how to get the Dimension Value or HTML Row

subash29 — Tue, 31 Oct 2017 13:58:26 GMT

Thank you for the reply i can able to get the row count using

var rowCount = table.rowCount;

but i want the particular dimension column values or the binded html to bind the my custom functions;

I dont know how the listener help to get the data?

Re: From Table API in Qlik Sense how to get the Dimension Value or HTML Row

_jespers_ — Tue, 31 Oct 2017 14:09:33 GMT

If you look at my example where I loop through the data.

The variable "value" will contain all the different dimension & measure values for the current row, or is this not what you are after?

Re: From Table API in Qlik Sense how to get the Dimension Value or HTML Row

subash29 — Tue, 31 Oct 2017 14:21:58 GMT

Hi jesper,

When i tried to add the below variable from table is affecting my js

var data = table.qHyperCube.qDataPages[0].qMatrix;

Re: From Table API in Qlik Sense how to get the Dimension Value or HTML Row

_jespers_ — Tue, 31 Oct 2017 14:26:04 GMT

Hi,

Have you added this to your .js-file:

initialProperties : {
                qHyperCubeDef : {
                    qDimensions : [],
                    qMeasures : [],
                    qInitialDataFetch : [{
                        qWidth : 10,
                        qHeight : 50
                    }]
                }
            },

Re: From Table API in Qlik Sense how to get the Dimension Value or HTML Row

subash29 — Tue, 31 Oct 2017 14:42:24 GMT

I am new to this hypercubles

i didn't created any hypercubes yet i dont know where to add this in my js files ?

Re: From Table API in Qlik Sense how to get the Dimension Value or HTML Row

subash29 — Tue, 31 Oct 2017 14:43:34 GMT

Re: From Table API in Qlik Sense how to get the Dimension Value or HTML Row

ErikWetterberg — Tue, 31 Oct 2017 21:29:40 GMT

What do you want to do? The table API helps you work with the data from the hypercube, it does not help you with HTML rows or any other HTML. For that you need standard JavaScript possibly with the help of some library like jQuery, which is included with Qlik Sense.

Hope this helps

Erik Wetterberg

Re: From Table API in Qlik Sense how to get the Dimension Value or HTML Row

subash29 — Wed, 01 Nov 2017 07:31:29 GMT

i have to create the simple table with dimensions,measure and total,avg v values for measure will show on ranking order of measure values.

Re: From Table API in Qlik Sense how to get the Dimension Value or HTML Row

ErikWetterberg — Wed, 01 Nov 2017 08:56:16 GMT

With Qlik Sense Desktop installation comes some example extensions. You'll find them in My Documents\Qlik\Examples\ Extensions. Among them is a SimpleTable extension you can use as a starting point. If that does not suite your needs, look for a more advanced one in Qlik Branch.

Hope this helps

Erik Wetterberg

Re: From Table API in Qlik Sense how to get the Dimension Value or HTML Row

ErikWetterberg — Fri, 03 Nov 2017 09:05:21 GMT

Hi,

Just wanted to let you know that there is a new tutorial on extensions available at Qlik Branch. And they have a table as tehir example extension.

Hope this helps

Erik Wetterberg