Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
t_hylander
Creator
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.

Thanks in advance!

1 Solution

Accepted Solutions
sunny_talwar

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
sunny_talwar

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

Anil_Babu_Samineni

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
t_hylander
Creator
Creator
Author

Thanks!

Just what I wanted.