topic Re: Invalid dimension (calculated dimension) - Qlik Sense in QlikView

Invalid dimension (calculated dimension) - Qlik Sense

guyvermeiren — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Invalid dimension (calculated dimension) - Qlik Sense

Chanty4u — Thu, 14 Jun 2018 13:01:02 GMT

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

Re: Invalid dimension (calculated dimension) - Qlik Sense

vkish16161 — Thu, 14 Jun 2018 13:01:35 GMT

For limiting the values - Try this in QS.

LIMITATION

then Fixed Number