topic Re: Variable creation in QlikView

Variable creation

Sun, 26 Aug 2012 11:02:30 GMT

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.

Re: Variable creation

swuehl — Sun, 26 Aug 2012 11:43:54 GMT

Are you looking for something like this?

TABLE:

LOAD * INLINE [

Test

];

LET vNumRows = NoOfRows( 'TABLE' );

Re: Variable creation

Mon, 27 Aug 2012 07:36:01 GMT

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

Re: Variable creation

jonathandienst — Mon, 27 Aug 2012 08:09:00 GMT

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

=vNumRows

in a text box.

Regards

Jonathan