topic Caluculated dimension with a function in QlikView

Caluculated dimension with a function

Anonymous — Sat, 16 Jan 2016 08:21:12 GMT

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

Re: Caluculated dimension with a function

Gysbert_Wassenaar — Sat, 16 Jan 2016 09:40:16 GMT

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.

Re: Caluculated dimension with a function

Anonymous — Sat, 16 Jan 2016 12:48:27 GMT

Thanks Gysbert

Re: Caluculated dimension with a function

sunny_talwar — Sat, 16 Jan 2016 13:56:16 GMT

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?