topic Axis size with Aggr() should not react to selections in list box in QlikView

Axis size with Aggr() should not react to selections in list box

Janneke — Fri, 20 Oct 2017 11:50:58 GMT

Hi all,

I have a column table where the size of the axis depends on the max of two charts:

=If(Max(Aggr(NODISTINCT Sum({1<DimensionA={1},DimensionB={2}>}Value),Date))>=Max(Aggr(NODISTINCT Sum({1<DimensionA={2},DimensionB={2}>}Value),Date))

,Max(Aggr(NODISTINCT Sum({1<DimensionA={1},DimensionB={2}>}Value),Date))

,Max(Aggr(NODISTINCT Sum({1<DimensionA={2},DimensionB={2}>}Value),Date))

)

I use 1 in set analysis so that the chart doesn't respond to selections in list boxes. However, this doesn't apply on this formula for the axis size. I think the reason is the Aggr() with Date.

Can anyone explain to me what I need to change in order to get this working?

Thanks in advance, greetings, Janneke.

Re: Axis size with Aggr() should not react to selections in list box

jonathandienst — Fri, 20 Oct 2017 11:55:09 GMT

To prevent the Aggr() from reacting to selections, you need a {1} in the enclosing Max() as well as inside:

Max({1} Aggr(.....)

Re: Axis size with Aggr() should not react to selections in list box

Janneke — Fri, 20 Oct 2017 11:59:46 GMT

Brilliant!!

Thanks for the quick respons.