Hi All, I have one Table View in an Omniscope tab in which I am selecting certain rows from source DB say 100. Then I am creating certain filters on the Table View data which reduces the data to 50. And then a Sort.
After sort I want to display only top 5 records in final view of table. I am not able to find anything to do that. Can someone please help on limiting the records to 5.
Section 4 of this page shows how to construct Top/Bottom N classifications which can be combined with Named Queries or other filter settings to display only the Top/Bottom N records based on a specific field:
Thank you for replying back. I have one limitation here.
In my data explorer I have a large table of 50,000 records. In a tab I am creating 10 table views each of them have some data (with filter using named query) from that main table.
Now If I am using rank function for top 10(As in the example) in any table view of tab. Ranking is based on the main table not the table view in the tab(Ranking is based on the 50,000 values not the data which is in table view). So it is difficult to select top 10.
Cannot we have ranking for table view inside tab. Independent of main table.
Jagran - If you want to calculate sub-rankings for defined subsets of the data set, you must add the Subset Function syntax to your RANK function. The Subset function syntax is described on this page which includes an example of using a Subset 'clause' with the RANK function:
where 'DefinedValueN' can be a Variable, and where the same Field name is repeated in the case that the defined subset contains all values in a given [FieldtoConsiderN]. Operators must be = for Text/Categories, but can be =, !=, GTE, LTE for Numeric values and Date/Times.
The sample RANKING function file on this page also shows examples of using RANK with SUBSET 'clauses':
Yes, you can use Variables as defined values within SUBSET clauses, and also classify records as Top-10 or not in a Formula Field and use 'Top-10' as one of the values defining the subset to display: