topic Re: Compromise a qvf file to the first 100 records in App Development

Compromise a qvf file to the first 100 records

Anonymous — Tue, 19 Jun 2018 18:10:24 GMT

Hello,

I have a saved application and i need to compromise it to a smaller .qvf as i need to send the first 100 record by email

Do you have an idea how can i load the first 100 record from the data load editor without using a script?

Thank you,

Re: Compromise a qvf file to the first 100 records

felipedl — Wed, 20 Jun 2018 16:20:50 GMT

Hi Mustafa,

Didn't quite understand what you meant without using a script but on the data load editor, for each table you have on your final model, you can use the First [Number of rows], in your case First 100, to get only the first 100 loaded lines per table.

Something like:

First 100

Table:

Load

From [Whatever];

Felipe.

Re: Compromise a qvf file to the first 100 records

rwunderlich — Mon, 23 Jul 2018 16:28:29 GMT

In the script editor, you can enter the debugger and do a limited load of 100 rows. If you can't reload, I'm not sure how you can reduce.

-Rob

Re: Compromise a qvf file to the first 100 records

dwforest — Mon, 23 Jul 2018 16:38:02 GMT

You could possibly use Rank() function to determine first 100; they apply a filter to a table object and export data....

Re: Compromise a qvf file to the first 100 records

BalaBhaskar_Qlik — Mon, 23 Jul 2018 16:49:59 GMT

Not possible, without using Load script to decrease the record count of .QVF file to 100 records.