Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Max rows number in a Straight Table

Hi all,

I have a Straight Table in which I want to display a maximum of 1,500 lines, how can I do?

I don't have a Dimension (or a Always Available Dimension), the Straight Table is a Dynamical Straight Table.

I don't want to use Macros.

Thanks for help.

Bye

Adriano

1 Solution

Accepted Solutions
sunny_talwar

May be something like this:

=If(RowNo(TOTAL) <= 1500, YourExpression)

View solution in original post

3 Replies
sunny_talwar

May be something like this:

=If(RowNo(TOTAL) <= 1500, YourExpression)

Clever_Anjos
Employee
Employee

If your table does not have a dimension, how could it have more than one row?

A bit confused here

Not applicable
Author

I have 30 dimensions and I choose what visualize in every moment with a selections in a List.

So I don't have a dimension always available but I have 30 dimensions available.

Bye

Adriano