topic change of color on barchart in QlikView

change of color on barchart

t_hylander — Wed, 01 Aug 2018 13:32:09 GMT

Hi,

Have a simple combochart showing result vs budget with full ackumulation; (bars is result, and line budget)

What Id like is that bars after july (since aug numbers isnt in yet) should be a diffrent shade. Ofcourse this should be dynamic so when its september, then okt and onward should be a diffrent shade.

Made a small example with just the core numbers if you need something to play around with.

Thanks in advance!

Re: change of color on barchart

sunny_talwar — Wed, 01 Aug 2018 13:38:29 GMT

Try a background expression like this

=If(Month(Date#(Only({1} Month), 'MMM')) < Month(Today(1)), RGB(154, 198, 188), ARGB(100, 154, 198, 188))

Re: change of color on barchart

Anil_Babu_Samineni — Wed, 01 Aug 2018 13:39:44 GMT

Try this as BG color?

If(MonthNum <= Num(Month(Today())), Green(), Yellow())

Where as MonthNum created by script like Num(Month(Date#(Month,'MMM')))

Re: change of color on barchart

t_hylander — Wed, 01 Aug 2018 13:45:34 GMT

Thanks!

Just what I wanted.