Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
t_hylander
Contributor

change of color on barchart

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!

1 Solution

Accepted Solutions

Re: change of color on barchart

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))

Capture.PNG

View solution in original post

3 Replies

Re: change of color on barchart

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))

Capture.PNG

View solution in original post

Re: change of color on barchart

Try this as BG color?

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


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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
t_hylander
Contributor

Re: change of color on barchart

Thanks!

Just what I wanted.