Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to loop through a list of loaded. What si the best way to do this.
I have been trying to use
LET
NoofTables = NoOfRows('$Table');TO get how many tbale sare loaded, but this doe snot return a value.
hi alan,
you can either create a list box with $Table as field to see the names of the table or use
let x=tablename(1);
it will give the name of the 1st table loaded
similarly,
let x=tablename(2); will give the name of the 2nd table loaded
thanks
hi alan,
use the nooftables() function instead of noofrows()
let x=nooftables();
this should work and it will give u the no of tables loaded so far.
thanks
Thanks this works.
How do I then look through the $table table to get the table name?
hi alan,
you can either create a list box with $Table as field to see the names of the table or use
let x=tablename(1);
it will give the name of the 1st table loaded
similarly,
let x=tablename(2); will give the name of the 2nd table loaded
thanks
Thanks this works.
I could not find these functions in the help file. Is ther any documentation on them?
hi alan,
you can refer the QlikView Reference manual in C:\Program Files\QlikView\Documentation directory
thanks