Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Ok, I think I understood where the problem is.
I'm going to give it a try later today.
Thanks!!
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...
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.
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...
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...
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.
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 ...
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 ...