topic Re: row count in QlikView

row count

Fri, 12 Dec 2014 11:52:27 GMT

how do you count the real number of rows in a table (i.e. what's going to be visible) within the load script?

Re: row count

Gysbert_Wassenaar — Fri, 12 Dec 2014 11:58:40 GMT

What's going to be visible depends on how you construct the chart objects. So you determine the 'real' number of rows. If you want to know the number of rows loaded into a table in the script you can use the NoOfRows function:

LET vNoOfRows = NoOfRows('MyQlikViewTable');

Re: row count

MK_QSL — Fri, 12 Dec 2014 12:00:41 GMT

Use Script Function

NoOfRows(TableName)

Re: row count

its_anandrjs — Fri, 12 Dec 2014 12:02:40 GMT

Hi,

There is different ways

1. Add the field in front end $Table, $Row

2. By the variable

Let vNoOfRows = NoOfRows('TableName');

3. Add the field RowNo() in the table

Ex:-

Load Rowno() as Rowcount,FieldName;

Load * Inline

[

FieldName

];

Hope this helps

Regards

Anand

Re: row count

Fri, 12 Dec 2014 12:05:10 GMT

thanks

Re: row count

Fri, 12 Dec 2014 12:05:46 GMT

I’ll try those out, ta

Re: row count

Fri, 12 Dec 2014 15:03:22 GMT

Thanks, that works …