Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Carl,
Can you maybe show the calculation that you are creating
Jordy
Climber
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])]))