This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
i want to know the each table distinct count of rows in text object
how can i do this?
This is a script function which can be used to create a variable to store the row count of each table and then displayed in the text box object on the front end
LET vNoOfRowsTable1 = NoOfRows('Table1');
and then display this in the text box object
View solution in original post
May be do a distinct count of the unique identifier from each table... make sure that this field is not a key field which connects two tables...
but what is =Numofrows function gives?
and how to use that?
I believe it gives the number of rows in a particular chart when used on the front end... read here
im thinking about this
Okay thanks sunny
can i use this in text object like this?
=$(NoOfrows) ? is this correct?
Well depending on your variable... you can do this vNoOfRowsTable1 or $(vNoOfRowsTable1)... one of the two should work....