Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Variable creation

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.

3 Replies
MVP
MVP

Re: Variable creation

Are you looking for something like this?

TABLE:

LOAD * INLINE [

Test

A

B

B

C

C

C

];

LET vNumRows = NoOfRows( 'TABLE' );

Not applicable

Re: Variable creation

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

MVP
MVP

Re: Variable creation

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser