Limit keyword in pql statement

Hello All,

Please is it possible to use the LIMIT or TOP X keyword in a PQL statement.


you could limit the output of a PQL statement using the INDEX_ORDER function (read more on With this function you can numerate the results of a statement and therefore also limit the output to a specific number of results.

Best regards,

Thank you. I will take a look at the function.

Hi kalversberg,
So I as able to rank the spend column using the INDEX_Order function. I am unable to limit it to say 10 outputs. How can I achieve this.



you can use the formula as a component filter:
FILTER INDEX_ORDER(PU_SUM(“purchase_orders”,“purchase_order_lines”.“reporting-total”)) <= 10


Great. Thank you for your prompt feedback