QlikView Bar Chart - Background colour not working with IF statement

[NickBentley]

Hi,

I have previously successfully used If statements for the colour of bars in bar chart based on the sales year.

However, when I set the background colour to RGB (49,130,189) it works as expected but the If statement   IF(SSDate_CY ='2023',RGB (49,130,189)) does not. 

Anyone got any ideas why it is not working as expected as the statement was copied from a chart in another QV app that worked 100%

Thanks in advance! 

[Anil_Babu_Samineni · Accepted solution]

This should work, Could be you don't have in bar with 2023 data? 

Or, try with Pick(Match(SSDate_CY, 2023), RGB(....))

[NickBentley]

Thank you Anil_Babu_Samineni. 

I was able to get it working using the Pick Match solution.

PREVIEW