Discussion board where members can get started with QlikView.
I wrote script to create the tables and the relationship, but i cannot figure out how to create a variable and assign to it the number of rows of a specific table.
I need this when creating a percentage graph.
Are you looking for something like this?
LOAD * INLINE [
LET vNumRows = NoOfRows( 'TABLE' );
ok i did all this and created vNumRows in settings => variable overview.
but when i want to show this in a text object, it appears as NoOfRows( 'TABLE' ) not a number
how can i fix this???
Thanx for the reply
That form of NoOfRows is only usable during script. If you want to display it in the front end, use Stefan's script to create a variable, and then display the variable value. Put
in a text box.