topic Re: Adjusting reference line for drilldown dimension in App Development

Adjusting reference line for drilldown dimension

qliklearner11 — Sat, 16 Nov 2024 20:27:12 GMT

Dear all,

I have a chart with a drilldown dimension and I want the reference line (showing the average) to adjust automatically to the second dimension.
Take for example the image below. The reference line displays the average sales of all countries. If I select Germany now, I want the reference line to adjust to the sales of German countries, i.e. displaying the average sales above all German cities.

Or is there a possibility to hide the reference line when going into the second dimension?

Many thanks for any help!

Re: Adjusting reference line for drilldown dimension

Lisa_P — Tue, 16 Jul 2019 00:53:37 GMT

You could add two reference lines, one for Country Average and one for City Average and they would both be visible, but the Country average would be out of range when you select a single country

Re: Adjusting reference line for drilldown dimension

QlikWizard — Thu, 29 Aug 2019 13:50:27 GMT

Hey Qliklearner11,

You should be able to do something like this.

=Avg(Aggr(Avg(Sales),"$(=If(IsNull(GetFieldSelections(Country))=True(),'Country','City')"))

Let me know if it doesn't work