Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
your thisyear value is null. see the below snapshot.
may be, you can try this
if( IsNull($(thisyearsale)) or ($(allyearssale))<($(thisyearsale)),green(),Red())
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?