Is it possible to make a view with a top 10 only?

Thanks! working fine. I would like to add a selection field and use this selection to filter... It s a composite table where I have my view and the selection, but it seem to not working... in the (select ) it wont take care of my selection...

what could be the problem?

thanks

Hi, It s working but the only problem is that I need to have a new Rank column for each condition. So if my search criteria changes, I need to add a Rank column to the table...

I m trying to use a kind of array function to remove some entry according to the 'Top N' field but it s hard to make something works...

wath do you suggest?

ok! because I'm able to get an array with the good value, but I don t know how to fill the view table with it! Your method with the rank value works fine but like I said, if I have a table with some purchased and each item purchased is type_A or Type_B and it could be done at location_A and Location_B and location_C then I would need to have a rank for each condition or so... and it s a lot! (type_A & location_A, type_A & location_B, type_A & location_C, type_B & location_A....) 

it s a lot just to extract a pre defined number of row in a view...

do you have any idea to do it simple?

With my array I can insert an item() in the criteria but I need to tell the criteria != to all value in my array...that s where the issue came out...

I want to make a view table that show only a top 5 value or so. But to show only a number of value, I need to filter after filtering. 

let say: let A := sort((select Achats).total_vente);
let B := null;
let j := number_show_1 - 1;
let x := cnt(A) - 1;
for i in range(x, j) do
let B := B + item(A, i);
B
end

this way I get the good value but in an array...I need to make a new filter but I don t know how to use it in filter...

(select Achats)[total_vente = B]

The 'rank' field is only to be able to filter but like I said if I change any of the filter option, I need a new 'rank' with the new filter... 

thanks!

yes that wath I m trying to do for now! I create a main table composite to all other... then I create my view table on the main form with 2 selection field. Here my code inside the selection field 'on update' formula... seems to have an issue with it! I come close but there s something...

let sort := null;  
let type_atel := text('Type atelier'); ------> 'selection field 1'
let sort := if text(Type_produit) = "Accessoire" then  ----> variable with sorting value...
"total_accessoires"
else
if text(Type_produit) = "Epice" then
"total_aliments"
else
"total_vente"
end
end;
let r := cnt(select Achats);
let a := cnt((select Achats)[text(Atelier.'Type d''Atelier') = text(type_atel)]);
for p in select Achats do
p.(Rank := null)----> set all rank to null before to set it...
end and for p in (select Achats)[text(Atelier.'Type d''Atelier') = text(type_atel)] order by text(sort) do
p.(Rank := a);
a := a - 1
end

can you help me with this? Thanks a lot!

seems to be the 'sort' that I m trying to use a variable to order values... should have a way to do it...