Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Janneke
Creator
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?

Thanks in advance, greetings, Janneke.

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
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

View solution in original post

2 Replies
jonathandienst
Partner - Champion III
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
Janneke
Creator
Creator
Author

Brilliant!!

Thanks for the quick respons.