Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
RowNo() function used to how many rows used in table. I attached a sample Qv file.
Hope its helpful for you.....
Regards,
Iyyappan
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.
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
Hi,
I attached a sample QV file. Hope its helpful for you.
Regards,
Iyyappan
while loading table
load *
rowno() as row
from path
after reloading
in titile write
=Max(row)
hope this help
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.
try
=' Max no of rows = ' & max(row)
Hi,
I didn't attach the correct file.
Really I am sorry for that.
Please find the correct file attached.
Regards
Andrew Hudson
Thanks for this. Exactly what I needed!