Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
selvapraveen
New Contributor II

Total number of rows in a straight table

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

8 Replies

Re: Total number of rows in a straight table

Try this:

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

YoussefBelloum
Esteemed Contributor

Re: Total number of rows in a straight table

Thanks for this

shiveshsingh
Honored Contributor

Re: Total number of rows in a straight table

Nice one

mukesh19
New Contributor II

Re: Total number of rows in a straight table

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

Re: Total number of rows in a straight table

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

mukesh19
New Contributor II

Re: Total number of rows in a straight table

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

Re: Total number of rows in a straight table

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

Luminary
Luminary

Re: Total number of rows in a straight table

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