Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Row count in Title of Straight table chart

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?

13 Replies
Highlighted
Specialist
Specialist

Re: count Rows in Straight table 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

Highlighted
Not applicable

Re: count Rows in Straight table chart

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.

Highlighted
Creator II
Creator II

Re: count Rows in Straight table chart

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

Highlighted
Specialist
Specialist

Re: Row count in Title of Straight table chart

Hi,

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

Regards,

Iyyappan

Highlighted
Champion
Champion

Row count in Title of Straight table chart

while loading table

load *

rowno() as row

from path

after reloading

in titile write

=Max(row)

hope this help

Highlighted
Not applicable

Re: count Rows in Straight table chart

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.

Highlighted
Not applicable

Row count in Title of Straight table chart

try

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

Highlighted
Creator II
Creator II

Re: count Rows in Straight table chart

Hi,

     I didn't attach the correct file.

     Really I am sorry for that.

     Please find the correct file attached.

Regards

Andrew Hudson

Highlighted
Not applicable

Re: Row count in Title of Straight table chart

Thanks for this. Exactly what I needed!