FAQ:Is there a possibility to limit the number of elements displayed in a list query?

From prevero Competence Center
Jump to: navigation, search
Last update: 01/2014

It is possible to limit the elements displayed in a list query to a certain number.

In the following example, we would like to display the 15 customers with the highest sales, i.e. those with the highest value in FR1:

The list query can be structured as follows:

SetDat(1;1;10001;4762;344203;select top 15 (F000) from prename_Z000 where zid>10000 order by F000 desc)

Please note that Professional Planner only displays the annual value in this formula.

See also[edit]