Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How to take the row count of a query which is there in the variable

Hi All

How can we get the count of rows in the below varible. For your information vQuery contains the query. How can I take the count of that query and assign it to a variable.

LET vCount=Count('$(vQuery)');

Hope someone can helpme out on this.

Thanks,

Attitude

Tags (3)
1 Reply
SunilChauhan
Esteemed Contributor

How to take the row count of a query which is there in the variable

why not use

let vcount=noofrows('tablename')