topic Re: Background color expression- problem for ambitous in QlikView

Background color expression- problem for ambitous

Anonymous — Wed, 05 Aug 2015 14:43:13 GMT

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.

Re: Background color expression- problem for ambitous

settu_periasamy — Wed, 05 Aug 2015 15:05:12 GMT

Hi,

your thisyear value is null. see the below snapshot.

may be, you can try this

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

Re: Background color expression- problem for ambitous

Anonymous — Thu, 06 Aug 2015 07:47:42 GMT

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?

Re: Background color expression- problem for ambitous

settu_periasamy — Thu, 06 Aug 2015 08:00:40 GMT

Hi,

Check these links

What language is QlikView written in?