Count of Rows Fetched

anwesha16 — Mon, 06 Sep 2021 08:23:16 GMT

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

Re: Count of Rows Fetched

stevejoyce — Mon, 06 Sep 2021 10:21:59 GMT

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)

]

;

topic Count of Rows Fetched in App Development

Count of Rows Fetched

Re: Count of Rows Fetched