Discussion Board for collaboration related to QlikView App Development.
Was trying to validate the records count from source->DB->QV(QVD)
creating one dashboard, which shows count of records table wise from source->DB->QVD
Can any one please let me know how to get the count of records in the QVD(Incremental load).
You can simply use the function QvdNoofRows() for this.
From the QV-reference manual:
Returns the number of records currently in a QVD file.
The filename is the name of a QVD file, if necessary including path.
So you can compare this number with the select count(*) FROM yourTable;
Thanks but I am trying to export the count to an excel format not in the QVW.
First Load your QVD(Incremental load). Then you can try with NoOfRows('TableName') or QvdNoOfRecords(filename) function.
From <Data Source>;
LET a = NoOfRows('Tab');
You can create a variable in the load script for get the no of records by using NoofRows() or QvdNoOfRecords ( ) like
Let vQVDRecords = QvdNoOfRecords ('C:\MyDir\MyFile.qvd');
Let vNOOrRecords = NoofRows ('TableName');
Update the script now check
Then try like
Let vQVDRecords = QvdNoOfRecords ('C:\MyDir\MyFile.qvd'); //It reads from the QVD rows
Let vNoOfRows = NoofRows ('TableName'); //It reads from the table loads
Load * inline
Store TableRows into TableRows.qvd(qvd); //But if you want to create the xls file change syntax but the file not created in xls format it is in txt file and after opening save it as xls file
Store TableRows into TableRows.xls(txt);
Please find attached an example .qvw where I show how it works.
- First I load some data to generate a .qvd (this is to simulate the .qvd you already have).
- then I trace the no of rows so you see it while reloading and in the logging (if activated)
- then this #rows is loaded inline
- then this is stored to a csv file
This could be extended to multiple .qvd's if needed.
Hope it helps.