Invalid dimension (calculated dimension) - Qlik Sense

[guyvermeiren]

Hello,

We are trying to create a calculated dimension to create a Top 15 in a table.

The formula is:

=If(Aggr(Rank(sum({$<[Opportunity Sub Status Code]-={$(vSubstatus)}>}[Opportunity Period Pipeline EUR])),[Opportunity Number])<=15,[Opportunity Number],null())

If we use the dimension we get a message "Invalid dimension". What is wrong ?

It works when using it in a table.

Thanks

Best regards,

Guy

[Chanty4u]

=If(Aggr(Rank(sum({$<[Opportunity Sub Status Code]-={$(=vSubstatus)}>}[Opportunity Period Pipeline EUR])),[Opportunity Number])<=15,[Opportunity Number],null())

[vkish16161 · Accepted solution]

For limiting the values - Try this in QS.

LIMITATION

then Fixed Number