Re: Get first 100records of any logical table with vbs
you can create a new sheet into your Qlikview document (you can hide it) and insert a table box object (example with ID = "TB01"). Next you add all the fields of your data table to this table box object. If you don't want current selections affect data lines into the table box create a new "alterante state" into your document and connect it to the table box. To the sure to extract the first 100 rows exactly as you have load it, you can crate an automatic row counter (using RowNo() AS IDRow into your realod script) and order data into table box using this field.
Copy and paste the following code into your VBS module :