Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
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.