Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how do you count the real number of rows in a table (i.e. what's going to be visible) within the load script?
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');
Use Script Function
NoOfRows(TableName)
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
thanks
I’ll try those out, ta
Thanks, that works …