Caluculated dimension with a function

[Anonymous]

I had the following calculated dimension in my QV application:

Now i want to replace with something like the following:

Is the above workable?

Regards

[Gysbert_Wassenaar · Accepted solution]

Yes, an expression like this should work:

=If(aggr(Rank(Sum(Amount)),$(=GetCurrentField("LeadingACT3")) )<=20,$(=GetCurrentField("LeadingACT3")))

But in most charts you can use dimension limits instead which are a lot easier and will probably perform better.

[Anonymous]

Thanks Gysbert

[sunny_talwar]

If the issue has been resolved, would you be able to close this thread? If it hasn't been resolved, would you be able to point out what isn't still working?