Need to show only 100records in Straight Table

[MS90]

in my data there are more than 1million records while loading data in Straight Table I need to show only latest 100 records

Noofrows and rowno function is not working in calculation condition 

[Or]

Calculation condition does not impact the number of rows shown. It decides whether or not the entire table is calculated.

Either use the new Straight Table object (from the May 2023 version) and the Pagination option, or use the Dimension Limitation option from the regular table object to display the Top 100 (your first measure would need to be the record's date) or use Rank() as suggested in a number of previous threads here, e.g. https://community.qlik.com/t5/QlikView-App-Dev/How-to-display-Top-10-rows-in-pivot-table/td-p/134888...

[MS90]

There is no measure in the data

[Lokesh_5045]

While you are referring latest 100 records, hope the table is sorted based on Date or any other field.

In table visualization, select the proper dimension and use limitation to exact number 100.