Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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.

Community Browser