# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for
Did you mean:
Creator

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

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?

1 Solution

Accepted Solutions
Partner - Champion III

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

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
2 Replies
Partner - Champion III

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

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Creator
Author

Brilliant!!

Thanks for the quick respons.

Community Browser