Qlikview 11 Extension and this.data.rows.length

[#1]

Hello,

I have a question regarding the this.data.rows.length function in the Qv extensions.

I have made an extension that tries to cycle through the possible values loaded in qlikview to compare to something loaded by the extension but when I do:

[blah blah]

var _this = this;

if ($.isEmptyObject(file)) {

                $.ajax({

                    url: file_path,

                    type: "GET",

                    success: function(data){

                         alert(" _this Data Rows Length " + _this.Data.Rows.length);

                         var info = $(data).find("info");

                         $.each(info,function(){ alert("OK"); [BLAH BLAH BLAH] } );

                    }

               });

     }

[blah blah]

The alert result is always " _this Data Rows Length 0 "

Yet the other function works perfectly fine, so the external data loaded by the function is actually there.

Did I forget anything obvious?

Thanks

[Nicole-Smith]

This thread contains a working (and easy!) example of how to use this.Data.Rows.length:

http://community.qlik.com/thread/52038

You can add an alert to see that it actually alerts the correct number.

[#3]

Ok, I think I understood where the problem is.

I'm going to give it a try later today.

Thanks!!

[#4]

Hi Nicole,

I tried with the hint you gave me with that other discussion but it seems I can't get to read the data in Qlikview:

function test() {

    Qva.AddExtension('test', function () {

        //Declaring a two dimensional array (an array of arrays)

          alert (this.Data.Rows.length);

        var row = new Array(this.Data.Rows.length + 1);

});

}

Simply doing this gives me back a resulting alert with content "0".

Obviously the data I give the extension isn't quite 0, actually on the 20k rows range.

I seem to be at a halting point, not even being able to read any data at all from Qlikview with an extension...

[Nicole-Smith]

This won't show anything on the extension object, but it will alert the number of rows...

Hopefully this can help you out a bit.

[#6]

I see the point here and I had given it a try already myself..

Unfortunately it looks like:

1) I'm loading data from an excel workbook with 27000 records

2) a qlikview listbox shows all of the records correctly

3) this.Data.Rows.length always returns 0, whichever field I may choose

I'm now wondering if the problem is that I may have too many records or the data is numeric...

[Nicole-Smith]

Is there any way that you can post a version of your data?  I can't really help any further without seeing the data that is giving you the problem...

[#8]

I'm very tired with Qlikview Workbench, is so sad!!!

But, Data.Rows use a array like this

Data.Rows[0][0].text,
Data.Rows[1][0].text;

Data.Rows[2][0].text;

But i have the same problem, its result just 100 values!!!

If can you get more than 100 please, help me too.

[#9]

Hi,

I have exactly the same problem : full of data in my QV objects but this.Data.Rows.length always =0.When I test my object, i obtain the same result ... : Qv.GetCurrentDocument().GetObject("Server\\TB02").Data.Rows gives me as result :  []

Thanks by advance for your future help ...

[#10]

I've tested this in another extention  (The QV console extension) and i'm not able to see the QV document datas... There is security rules that block this possibility ? note :my server  configuration is QV Server + IIS7.

Thanks by advance for your future help ...