Skip to main content
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating area chart with negative values

Hi All,

Please refer to attached file. I am trying to create an area graph which aggregates values at Level 07. The problem is that the 'Other' category at Level 07 has negative values which is throwing the chart off ( see the green block in Chart 1). If I exclude 'Other' in Level 07 we get chart2 which looks good. is there a way to chart the other category and its negative value so that they appear on the chart in a more visually intuitive fashion? For example, the y-axis going down into the negative or something along those lines.

Shall appreciate your help.

0 Replies