Search code examples
spotfire

spotfire limit row count of a table visualization

I am trying to limit the number of rows displayed on the visualization by having a property control(input field) in the text area. I was able to create the property control but wondering how to actually apply in the properties window under "Limit data using expression". Is there a way I can specify like RowCount = ${LimitRows} where the LimitRows would be my property control.

Solution

  • Assuming LimitRows is a numeric property (integer, real etc.) you can use the expression below to limit the data.

    rowid()<=${LimitRows}