Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Qlikview 11 Extension and this.data.rows.length

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

10 Replies

Re: Qlikview 11 Extension and this.data.rows.length

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.

Not applicable

Re: Qlikview 11 Extension and this.data.rows.length

Ok, I think I understood where the problem is.

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

Thanks!!

Not applicable

Re: Qlikview 11 Extension and this.data.rows.length

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...

Re: Qlikview 11 Extension and this.data.rows.length

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.

Not applicable

Re: Qlikview 11 Extension and this.data.rows.length

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...

Re: Qlikview 11 Extension and this.data.rows.length

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...

Not applicable

Re: Qlikview 11 Extension and this.data.rows.length

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.

Not applicable

Re: Qlikview 11 Extension and this.data.rows.length

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 ...

Not applicable

Re: Qlikview 11 Extension and this.data.rows.length

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 ...