Count of Rows Fetched

[anwesha16]

Hi fellow Qlik users, 

Is there a way I can display the total rows fetched (the count that shows in the data load editor while reloading data) on the dashboard like a KPI?  
Also, I’d like it to be dynamic in a way such that I am able to identify the difference in rows fetched daily (assuming the dashboard refresh daily with new data). 

#qliksense #rowcount #rowsfetched #count

[stevejoyce]

After any table load in your load script you can add a variable

let vNumberOfRows = NumberOfRows('table_name');

you can store each table for each day in a log table, something like this:

let vLoadDate = today();

let vTableName = 'table_name';

$(vTableName):

load

*

from your source;

let vNoOfRows('$(vTableName)');

dataload_log:

load * inline [

LoadDate, TableName, NumberOfRows

$(vLoadDate), $(vTableName), $(vNoOfRows)

]

;