A - I dont understand your question here. RowNo is a field and RowNo() is a function. The field must have come from your data source or was created by the load process - it is not a built in field.
B - test each one to see which you prefer
C - I think RowNo() and RecNo() are both populated before the cross table is expanded. So they refer to the pre-cross tabled data.
D - RecNo() refers to the input rows, RowNo() refers to the output rows. There will be a difference if you are filtering the data (eg with a Where / Distinct / Join / Keep). They also differ when you using a preceding load - RecNo() is only populated at the lowest level and RowNo() is only populated at the highest level of the preceding load.
E - RowNo(TOTAL) is a table function meaningful in the front-end (counts the row number across all dimensions). You cannot use it in the load script.
A RowNo just "appears" when I start to write RowNo() ... and gives me an error - not sure where itcame from.
B in terms of maintenance - I would need to add the row number in Excel each time records were added - rather than let Qlik do it - so best to let let Qlik do it (when comfortable that is is working as expected)
C. I got a "oh no" moment when loading the data - ordinary count worked but then when re-loaded I needed to add distinct to one set of calcs and needed to not use distinct in another set of calcs - those with the crosstable. From this i have learnt best to CONTROL by using Distinct or not using Distinct ....
D. so if I want a primary key and this to be static - best to use RecNo()
E. Do you mean at load when Qlikview gives you the number of rows loaded per table?That would be really handy. I have been going to settings and exporting the summary of table and fields. So I know and use = 'Last Reloaded: ' & ReloadTime( ) which i put on a text object - how do I do this for rows per table please?
Thank you Jonathan
>>RowNo just "appears" when I start to write RowNo() ... and gives me an error - not sure where itcame from
That's the editor auto-complete. Yow will get an error without the parenthesis because it is an error.
>>so if I want a primary key and this to be static - best to use RecNo()
That depends on your data and your requirements. Either one can do the job.
>>Do you mean at load when Qlikview gives you the number of rows loaded per table
No -that is still the load script. in the script, use NoOfRows('myTable') to get the loaded rows in the table named 'myTable'.