topic Re: howmany rows in a table in QlikView

howmany rows in a table

Anonymous — Tue, 15 May 2012 06:29:53 GMT

I think it should not be that difficult, but somehow I can't find the answer.

We have a straight table containing ofcourse data ;-), now we want to show the number of rows of that table in the header of the table.

How to do stuff in the header is not the problem, but how to get the number of rows displayed??

Anyone knows how to get the number of rows in the table??

In the development environment the number of rows is displayed in the bottom of the screen when selecting the table . . . but in de accesspoint environment ofcourse this is not available . . .

Is there a function to get this?

NoOfRows() gives just the number 1

Re: howmany rows in a table

Tue, 15 May 2012 07:49:46 GMT

Hi Anita:

Hope the attached App would help you.

Thanks,

Narasimha K

howmany rows in a table

Tue, 15 May 2012 07:50:00 GMT

Hi Anita,

did you try with =count(<field_from_table>) ?

regards

howmany rows in a table

Anonymous — Tue, 15 May 2012 08:11:15 GMT

The count function will not do the trick I guesse.

The straight table contains data combined from more data-tables which could give more rows than the original table has.

If I count(<field>) this gives only the number of fields for the table the field belongs to, not the physical number of rows the straight table has.

Re: howmany rows in a table

Tue, 15 May 2012 08:46:00 GMT

Attached is the macro snippet to fetch the number of Physical rows from a Straight Table.

Sub NoofRows

set table = ActiveDocument.GetSheetObject("CH01")
rows = table.GetRowCount - 1
msgbox "Number of Rows in Straight table is " & rows

End Sub

Hope that helps...

howmany rows in a table

Tue, 15 May 2012 08:54:19 GMT

In that case you should use set analysis with system attributes:

=sum({$<$Table={'<table_name>'}, $Field={'field_name'}>} $Rows)

regards

Re: howmany rows in a table

Thu, 20 Sep 2012 10:27:38 GMT

I had the same problem

simply use count(name of your first dimension)

In my case I give the label "Document" to the first dimension of my straight table and in the window title I added

=' Total rows : ' & Count(distinct(Document))

Re: howmany rows in a table

Teppo_Ojala — Tue, 19 Feb 2013 15:26:07 GMT

Hi,

I had the same challengr in one of my projects. I managed to write quite nice function to calculate number of expected rows in straight table.

My function is:

sum(aggr(1, <dim1>,<dim2>, <dim3> etc))

I have used QV11 functionality to hide/show fields chosen from basic listbox. Let's call the field by name "dimension_fields" - I have written a inline load to script that writes about 10 possible dimension to be used as columns in straight table.

Then I wrote a variable, for example v_chosen_dimensions and formula is

concat(dimension_fields, ',')

This variable has a value dim1,dim2 - if user has selected these 2 columns to be visible in straght table.

And then I changed my function to

sum(aggr(1,$(v_chosen_dimensions)))

I used this formula in "conditional show" to hide the straight table if amount of expected rows are greater than 300.

Hopefully I wrote all formulas correct way and hopefully this works in other cases also

Re: howmany rows in a table

Mon, 10 Jun 2013 15:28:39 GMT

Hi,

Did you figure out a way to do this? I am trying to achive this and none of the recomendations really helped. Appreciate if you can help me if you figured out a way to get the physical number of rows.

Thanks.

Re: howmany rows in a table

frankhuning — Thu, 05 Feb 2015 07:55:49 GMT

Based on Narasimha function, I use this:

Sub NoRowsInChart
set table = ActiveDocument.GetSheetObject("CH107")
rows = table.GetRowCount - 1
set v = ActiveDocument.Variables("vNrRows")
v.SetContent rows, true
End Sub

Where vNrRows is the name of my variable.

This Macro will be submitted by activating the sheet/chart through a trigger. In my chart header text I use the variable vNrRows

Regards Frank