Total number of rows in a straight table

[Anonymous]

I have a straight table with 24 columns and has around 20 dimensions in it.

I need to display the number of rows in the straight table in the table header.

I have already tired the below

count(distinct(dim1&dim2...))

rowno()

rowno(total)

count(expresion1)

Nothing works.... I could see the task bar of qlikview displaying the number of rows and colums when the mouse roll over the straight table. Is there a way to get that value in to the expression or can anyone suggest a method to display the number of rows in straight table

[sunny_talwar]

Try this:

Count(Aggr(RowNo(TOTAL), ListofYour20DimensionsHere))

[YoussefBelloum]

Thanks for this

[shiveshsingh]

Nice one

[mukesh19]

Is there any way to count the no of records rather than specifying the list of all dimensions

[sunny_talwar]

Not sure I understand your question. Would you be able to elaborate?

[mukesh19]

Instead of specifying all the 20 dimensions, is there any other alternative?

[sunny_talwar]

There might be... will depend on your dimensions, expressions and other chart properties

[pablolabbe]

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others