Row count in Title of Straight table chart

[#1]

Is it possible to count number of rows in straight table chart? How can I do that? I have a table chart with few dimensions, cycle groups and expressions. Since chart is too busy, an option was suggested to display number of rows present at any given time to restrict user from exporting to excel. If rows are higher then certain number user are warned before they export it to excel.  How can I get number of rows in a chart?

[v_iyyappan]

Hi,

     RowNo() function used to how many rows used in table.  I attached a sample Qv file.

Hope its helpful for you.....

Regards,

Iyyappan

[#3]

looks like we are going in the right direction. Now, How do I get that rownum in the title of the chart. For example, you have 4 as maximum number of rows in your test application. How can that be placed in the title of the chart where you have 'Sales  =  2969'. I want to replace title of the chart as 'Max number of Rows = 4' instead of 'Sales = 2969'. MAx number of rows changes every time chart updates with slice of the data.

[adhudson]

Hi,

     Please find the attached sample file.

     As well, This solution will respond to the selection made.

     i.e., it shows the number of currently visible rows in the straight after making any selection.

     Hope this helps.

Regards

Andrew Hudson

[v_iyyappan]

Hi,

I attached a sample QV file. Hope its helpful for you.

Regards,

Iyyappan

[SunilChauhan]

while loading table

load *

rowno() as row

from path

after reloading

in titile write

=Max(row)

hope this help

[#7]

Andrew:  There is nothing in QV sample document that you have attached. Please reattach.

Sunil: I create the table in GUI and not in load statement of QV ETL. your suggestion will not work for me.

Iyyapan : your seems to be the most helpful solution at this point.

[#8]

try

=' Max no of rows = ' & max(row)

[adhudson]

Hi,

     I didn't attach the correct file.

     Really I am sorry for that.

     Please find the correct file attached.

Regards

Andrew Hudson

[#10]

Thanks for this. Exactly what I needed!