row count

[#1]

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

[Gysbert_Wassenaar]

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');

[MK_QSL]

Use Script Function

NoOfRows(TableName)

[its_anandrjs]

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

a

b

c

];

Hope this helps

Regards

Anand

[#5]

thanks

[#6]

I’ll try those out, ta

[#7]

Thanks, that works …