topic Re: Tutorial on Hello Data not working in Integration, Extension & APIs

Tutorial on Hello Data not working

michael_andrews — Thu, 01 Sep 2016 20:50:04 GMT

I'm following this example

http://qliksite.io/tutorials/qliksense-visualization-extensions/part-01/08-Hello-Data/#

I was writing it myself, but I literally copy and pasted your example to make sure I didn't have any typos. Whenever I try to access the hyper cube data, I get an error because I get not arrow objects in my qDataPages array, so therefor no qMatrix.

The error I get is this

Here is what the data looks like.

So I'll post the code, but it's verbatim that project.

define( [],
  function ( ) {
  'use strict';


  return {


  definition: {
  type: "items",
  component: "accordion",
  items: {
  dimensions: {
  uses: "dimensions"
  },
  measures: {
  uses: "measures"
  },
  sorting: {
  uses: "sorting"
  },
  appearance: {
  uses: "settings"
  }
  }
  },
  initialProperties: {


  },
  paint: function ( $element, layout ) {


  var hc = layout.qHyperCube;
  console.log( 'Data returned: ', hc);


  // Default rendering with HTML injection
  $element.empty();
  var table = '<table border="1">';


  table += '<thead>';
  table += '<tr>';
  for (var i = 0; i < hc.qDimensionInfo.length; i++) {
  table += '<th>' + hc.qDimensionInfo.qFallbackTitle + '</th>';
  }
  for (var i = 0; i < hc.qMeasureInfo.length; i++) {
  table += '<th>' + hc.qMeasureInfo.qFallbackTitle + '</th>';
  }
  table += '</tr>';
  table += '</thead>';


  table += '<tbody>';

  for (var r = 0; r < hc.qDataPages[0].qMatrix.length; r++) {
  table += '<tr>';
  for (var c = 0; c < hc.qDataPages[0].qMatrix.length; c++) {
  table += '<td>';
  table += hc.qDataPages[0].qMatrix.qText;
  table += '</td>';
  }
  table += '</tr>';
  }
  table += '</tbody>';
  table += '</table>';
  $element.append( table );


  }
  };


  } );

Re: Tutorial on Hello Data not working

Stefan_Walther — Fri, 02 Sep 2016 04:25:11 GMT

‌Have a look at your initialProperties, they need to be defined (as also stated in the tutorial you are mentioning).

Hope this helps.

Regards

Stefan

Re: Tutorial on Hello Data not working

michael_andrews — Fri, 02 Sep 2016 15:06:11 GMT

Sorry, it was just a bad copy and paste. I was playing around with stuff to see if I could get it to work.

Adding

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

Doesn't solve anything

Re: Tutorial on Hello Data not working

Alexander_Thor — Fri, 02 Sep 2016 17:01:26 GMT

Make sure you delete the object from the sheet and re-add it again if you have modified the initalProperties as they are set on object creation.

Re: Tutorial on Hello Data not working

gustavgager — Wed, 10 May 2017 09:31:11 GMT

Hi.

Im doing the exact tutorial as you are. In the tutorial it say that you should just add "initialProperties: {}," and that sense will use this to default itself to what is standard.

However when you do that, you get this exact issue. No data in the hypercube.

But when you manually add the code

initialProperties: {

qHyperCubeDef: {

qDimensions: [],

qMeasures: [],

qInitialDataFetch: [

{

qWidth: 10,

qHeight: 100

}

]

}

Then it works.

is this something that has been changed in later versions of sanse?

Re: Tutorial on Hello Data not working

michaelpeter — Thu, 20 Jul 2017 12:40:26 GMT

Hi Michael,

I had exactly the same problem and found the solution while working further in the same tutorial.

Short explanation from what I have understood:

When using extra files like in this example './initialproperties', you need to create a parameter inside function(). Also, because initialdata is the second file I include, it also has to be the second parameter (at least that's what I think, I didn't test that). That parameter than has to be used instead of empty brackets.

Inside the files itself (here properties.js as well as initialproperties.js) you have to use

define( [], function () {

'use strict';

return {...}

}

and the inside of return{} is exactly what the belonging parameter will contain.

Hope this helps anybody ^^.

Michael

Hello-Data.js:

define(

[

'./properties',

'./initialproperties'

function ( props, initProps ) {

'use strict';

return {

definition: props,

initialProperties: initProps,

paint: function ( $element, layout ) {

var hc = layout.qHyperCube;

console.log( 'Data returned: ', hc );

$element.empty();

var table = '<table border="1">';

table += '<thead>';

table += '<tr>';

for (var i=0; i < hc.qDimensionInfo.length; i++){

table += '<th>' + hc.qDimensionInfo.qFallbackTitle + '</th>';

}

for (var i=0; i < hc.qMeasureInfo.length; i++){

table += '<th>' + hc.qMeasureInfo.qFallbackTitle + '</th>';

}

table += '</tr>';

table += '</thead>';

table += '<tbody>';

// iterate over all rows

for (var r = 0; r < hc.qDataPages[0].qMatrix.length; r++) {

table += '<tr>';

// iterate over all cells within a row

for (var c = 0; c < hc.qDataPages[0].qMatrix.length; c++) {

table += '<td>';

table += hc.qDataPages[0].qMatrix.qText;

table += '</td>';

}

table += '</tr>';

}

table += '</tbody>';

table += '</table>';

$element.append( table );

}

};

}

);

properties.js:

define( [], function () {

'use strict';

var dimensions = {

uses: "dimensions"

};

var measures = {

uses: "measures"

};

var sorting = {

uses: "sorting"

};

var appearance = {

uses: "settings"

};

return {

type: "items",

component: "accordion",

items: {

dimensions: dimensions,

measures: measures,

sorting: sorting,

appearance: appearance

}

};

} );

initialproperties.js:

define( [], function () {

'use strict';

return {

qHyperCubeDef: {

qDimensions: [],

qMeasures: [],

qInitialDataFetch: [

{

qWidth: 10,

qHeight: 50

}

]

}

};

} );

Re: Tutorial on Hello Data not working

yura_ratu — Mon, 10 Jun 2019 10:03:45 GMT

It's still the case. Very frustrating that official tutorial is incorrect for a good couple of years already

Re: Tutorial on Hello Data not working

Qlik_Trigg — Tue, 11 Jun 2019 12:56:29 GMT

Please note that qliksite.io is a private site not a Qlik official site. It is where the widget concept was incubated before Qlik brought it into standard product. Please reference the official Qlik help for supported documentation and tutorials on widgets

Re: Tutorial on Hello Data not working

yura_ratu — Tue, 11 Jun 2019 13:42:43 GMT

Ahh, sorry, haven't noticed the link in the first message and didn't know about qliksite.io. In my message I was referring to the official help page here https://help.qlik.com/en-US/sense-developer/April2019/Subsystems/Extensions/Content/Sense_Extensions/extensions-work-with-data.htm in "Create the main script file" section Initial Properties is empty.

Re: Tutorial on Hello Data not working

Qlik_Trigg — Tue, 11 Jun 2019 15:09:51 GMT

Thank you for the clarification Yura. We will have this looked at. Apologies

Re: Tutorial on Hello Data not working

durgesh22 — Fri, 18 Oct 2019 14:12:56 GMT

Deleting and adding an extension to the sheet solved my problem.

Thanks