Bar chart - how to show negative values in different colour and hide zero value (number)

[jamesjames]

Hi there,

I am using Qlik Sense on cloud.

For the colour I have tried this expression below and I added expression in:

Appearance -> Colours and legend -> By expression 

nfortunately both positive and negative values turns into green and also legend for colours and line disappeared (since I turned off auto)

1. How do I make legend for both values and line?

2. How do I make positive value green and negative value red?

3. How do I hide '0' number but keep the space ? ( I could choose not to show '0' but the gap disappears too.

[sunny_talwar]

Would you be able to share a qvf to try those things out?

[OmarBenSalem]

1) to not show zero values, under adds-on, uncheck show zero values

2) why do u have negative AND positive values for the the same dimension? Do u have 2 dimensions and are using the stacked bar representation?

If so, don't used stacked bar option but keep it seperated and then ur color would work..normally