topic Re: Background Colour (Full Accumulation) in QlikView

Background Colour (Full Accumulation)

Wed, 27 Jan 2016 09:08:16 GMT

Hi All

I’m trying to add a dynamic background colour based on the total accumulation for each respective month.

I’ve got Test and Test2 applications where I apply the exact same thing but not getting the same results.

What is the reason that Test2 is not working?…I’ve checked and really don’t get what is the problem.

I want to use this on Test2 as I have built a data model already.

Thanks!

Re: Background Colour (Full Accumulation)

MK_QSL — Wed, 27 Jan 2016 09:14:57 GMT

I can see that it's actually working... In reality you don't have any accumulated value >3000 so all bars are red.

You can try instead

IF(RangeSum(Above(SUM(SavingsAccount),0,RowNo()))<=2000,LightRed(),Green())

You can see that any bar having >2000 now becoming green.

Re: Background Colour (Full Accumulation)

Wed, 27 Jan 2016 09:26:33 GMT

Hi Manish

Thanks for the solution. works perfectly! I'm still a bit confused though...still don't understand why mine didn't work...anyway I'll give some thought

Thanks again!