Combo chart 0 value same on both axis

[blunckc1]

Hi,

I have a combo chart with data on both axis and I am wanting the 0 result to be the same on each.  Tried this solution Solved: Combo Chart - set zero value on both axis at same ... - Page 2 - Qlik Community - 1251683 but I am getting this error when using it.

"Error in expression: Nested aggregation not allowed"

I am using QlikSenseServer: 13.62.12, Feb 2020 patch 4.

Any ideas how to solve this?

Thanks

Carl

[JordyWegman]

Hi Carl,

Can you maybe show the calculation that you are creating

Jordy

Climber

[blunckc1]

Hey @JordyWegman 

The 2 measures being used in the chart itself are:

1 - Sum([YTD Budgeted FTE]) - Sum([YTD QH FTE]).  Formated as a number on the primary axis.

2 - Sum([YTD Budgeted AMT]) - Sum([YTD Amount]).  Formatted as a $$ on the secondary axis.

So the calculation being used to set the min/max range is:

=RangeMin(Min(Sum([YTD Budgeted FTE]) - Sum([YTD QH FTE])), Min(Sum([YTD Budgeted AMT]) - Sum([YTD Amount])))

=RangeMax(Min([Sum([YTD Budgeted FTE]) - Sum([YTD QH FTE])]), Min([Sum([YTD Budgeted AMT]) - Sum([YTD Amount])]))