Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Create text box
In the Write the expression like
=Count([Field Name])
Try
QvdNoOfRecords(filename)
Cheers,
DV
www.QlikShare.com
Hi,
COUNT() function can help you to achieve this.
Thanks
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;
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
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
It should go in the script.