topic Count Rows in Table Diagramm in QlikView

Count Rows in Table Diagramm

Wed, 10 Aug 2011 11:28:28 GMT

Hi, I am pretty new to Qlikview and got the following issue.

I created a table diagram like:

column A | column B | column C | column D
Value A         Value A     Value A          10
Value A         Value A     ValueB            20
Value A         Value A     Value C          3
Value A         Value B     Value A          12
Value C         Value A      Value A         77

and so on.

Now I want to know, how many lines do I have in this diagram?
When I use the count or text count function, Qlikview always counts the amount of rows in the root table ( database ).
I just want to know how I can count the lines / rows I got in the respective table diagram.

Thanks for your input,

Regards Mathias

Count Rows in Table Diagramm

kaushiknsolanki — Wed, 10 Aug 2011 12:51:53 GMT

Hi,

You can add a new expression as Rowno().

This will add numbers to chart rows.

Regards,

Kaushik Solanki

Re: Count Rows in Table Diagramm

SunilChauhan — Wed, 10 Aug 2011 12:56:11 GMT

Please see the attached file.

Re: Count Rows in Table Diagramm

its_anandrjs — Wed, 10 Aug 2011 12:57:25 GMT

Hi,

You also try to create Recno() in your load script that will create a Record no then you use it on the script.

See the attached file.

Regards,

Anand

Count Rows in Table Diagramm

Wed, 10 Aug 2011 14:51:31 GMT

Hi Guys,

thanks for your example files and answers.
I got it in the lines with the RowNo() expression. Now I try tro get this value into the title of the diagram.
Any thoughts on this.

Thanks so much Guys.

Regards,
Mathias

Count Rows in Table Diagramm

Wed, 10 Aug 2011 14:56:57 GMT

Hi Mathias,

You could load the rowno() or recno() as 'fieldx' in your table.

After that you can set the title in the diagram to ='Number of rows: ' & max(fieldx)

Regards,

Bert

Count Rows in Table Diagramm

Wed, 10 Aug 2011 15:03:14 GMT

Hi Bert,

Sorry for raising stupid questions: And how to I load the rowno() as "fieldx" in my table?

Thanks;
Mathias

Count Rows in Table Diagramm

Wed, 10 Aug 2011 15:14:28 GMT

Hi Mathias,

Stupid questions do not exist.

Here is an example:

load a,

rowno() as "Some sources rowno"

from 'some source.xls'

Regards,

Bert

Count Rows in Table Diagramm

rwunderlich — Wed, 10 Aug 2011 19:16:00 GMT

In a straight table, the number of rows will be equal to the number of unique dimension combinations. For a tablebox, the combinations will include all rows. So you can calculate the presumed row count in your title like:

=Count(Distinct [column A]&[column B]&[column C])

-Rob

http://robwunderlich.com

Count Rows in Table Diagramm

Wed, 10 Aug 2011 19:52:14 GMT

Rob! You made my day. That's exactly what I was looking for! great....

Cheers from Germany,
Mathias

Count Rows in Table Diagramm

its_anandrjs — Wed, 10 Aug 2011 19:53:04 GMT

Hi,

Please see the attached example it shows some thing like this

load *,recno() as Reco_No;

LOAD * INLINE [

column A, column B, column C, column D

Value A, Value A, Value A, 10

Value A, Value A, ValueB, 20

Value A, Value A, Value C, 3

Value A, Value B, Value A, 12

Value C , Value A, Value A, 77

];

Regards,

Anand

Re: Count Rows in Table Diagramm

hugmarcel — Tue, 22 Apr 2014 08:18:44 GMT

ok, but this solution does not work if dimension limits filter the table data...

Any solution available with dimension limits included?

thx - marcel