How can I count the records loaded into my table ?

[#1]

Hi,

I am loading a QVD file into my application. How can I count the total number of records loaded ? Is there a script statement which can do this ?

Thanks

MV 

[Anonymous]

Create text box

In the Write the expression like

=Count([Field Name])

[IAMDV]

Try

QvdNoOfRecords(filename)

Cheers,

DV

www.QlikShare.com

[Anonymous]

Hi,

COUNT() function can help you to achieve this.

Thanks

[#5]

Just take the maximum rownumber from the data you are loading. Use the rowno() function and then fetch the max rownumber from the resident table.

T1:

Load *,Rowno() as RowNumber from Table1;

T2:

Load Max(RowNumber) resident T1;

[sarvjeet · Accepted solution]

use statement below and after loading data from qvd 

let vRecordPre =NoOfRows('tablename');

// Load data from QVD

let vRecordPost =NoOfRows('tablename');

diffrence of two variable will give you new records

[#7]

Hi Deepak,

Where does this statement go ? In a text object ? In the script ?

I've tried both and it didn't like it.

MV

[#8]

It should go in the script.