Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for
Did you mean:
Creator

## 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.

1 Solution

Accepted Solutions
MVP

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

3 Replies
MVP

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

Try this as BG color?

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

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Creator
Author

Thanks!

Just what I wanted.

Community Browser