Background color expression- problem for ambitous

[Anonymous]

Hi.

I have two variable:

allyearssale for sum(sale) for present and previous years,

thisyearsale for sum(sale) only for present years.

I've created bar chart showing 'allyearssale' and I want to change background color so that values lower than 'thisyearsale' are green, and higher are red.

And I have no idea why I cannot. It mades me so frustrated that I allowed myself to ask you for help.

All data and qvd attached.

[settu_periasamy]

Hi,

your thisyear value is null. see the below snapshot.

may be, you can try this

if( IsNull($(thisyearsale)) or ($(allyearssale))<($(thisyearsale)),green(),Red())

[Anonymous]

Actually it wasn’t the problem, I solved it in another way. If you are interested check attachment. BTW what is language that QV is written by?

[settu_periasamy]

Hi,

Check these links

What language is QlikView written in?