topic Re: Get listbox values in extension in QlikView

Get listbox values in extension

nboccassini — Tue, 26 May 2015 07:03:30 GMT

Hi,

can you explain me how I can get the values (text) from a qlik listbox in a script.js of an extension?

Thanks,

Gab

Re: Get listbox values in extension

tresB — Tue, 26 May 2015 07:18:24 GMT

Check this: Re: Re: Passing data from qv to extension

Re: Get listbox values in extension

nboccassini — Tue, 26 May 2015 08:50:23 GMT

I want only the Age values and I have created these lines in Definition.xml

  <Dimension Label = "Age", Initial="Age" TargetName="Age"/>
      <Measurement Label="Age" Initial="Age" TargetName="Age" />

Can you explain me how use these lines in my script.js (attached)? I want to give (the first value) in the variable texta (of my script.js)

function InitSettings() {
// General Settings
// Chart Object ID: used to create a Unique Chart ID
_this.ExtSettings.UniqueId = _this.Layout.ObjectId.replace("\\", "_");
// Use _this.ExtSettings.Color in your main script if you want to setup the color of something.
_this.ExtSettings.Color = _this.Layout.Text0.text;
}

function InitData() {
   
    var dataset = [];
    for (var i = 0; i < _this.Data.Rows.length; i++)
    {
          var vMaker    = _this.Data.Rows[0].text;
          var vModel    = _this.Data.Rows[1].text;           
          var vType      = _this.Data.Rows[2].text;
          var vSales = parseInt(_this.Data.Rows[3].text);
       
          // I just put all data from the row into one node.     
          dataset.push({"Maker":vMaker , "Model":vModel    , "Type":vType      , "Sales":vSales , "index":i});
    }

Re: Get listbox values in extension

nboccassini — Wed, 27 May 2015 08:57:47 GMT

I have solved.

	var doc= Qv.GetCurrentDocument();
	var lb = doc.GetObject("LB01");

texta=lb.Data.Rows[1][0].value;

The last problem is that this solution work in access point, not in desktop version (Error Data.Rows.1.0 is null or not a object