Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Background color expression- problem for ambitous

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.

3 Replies
settu_periasamy
Master III
Master III

Hi,

your thisyear value is null. see the below snapshot.

Capture.JPG

may be, you can try this

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

Capture.JPG

Anonymous
Not applicable
Author

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
Master III
Master III