How to show negative values in bar chart?

[jamesjames]

Hi there,

I am learning how to create negative charts in Qlik Sense.

Basically I am trying to make chart below (from the Excel as an example), with positive and negative values.

For current bar chart in Qlik view I have two dimensions: 

1. Day (number of days)

2.  Name (that consists of cash it and cash out values)

Measures:

1. Amount EUR

How can I make negative values, meaning put red color opposite blue color?

[kaanerisen · Accepted solution]

Hi James,

Create dimensions for Day and Name fields.

After that, edit the Name dimension for giving colors to the values of that field.

Create a measure for Amount EUR field and the expression should be : Sum(IF(Name='Cash Out',-1,1)*Amount EUR)

After creating the bar chart and adding your dimensions and measure, go the measure properties of charts and make the modifications.

Change your bar chart appearance to stacked and it should be as you want.

Hope it helps...

[jamesjames]

Thank you!