topic QlikView Bar Chart - Background colour not working with IF statement in App Development

QlikView Bar Chart - Background colour not working with IF statement

NickBentley — Tue, 16 Apr 2024 23:47:43 GMT

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!

Re: QlikView Bar Chart - Background colour not working with IF statement

Anil_Babu_Samineni — Wed, 17 Apr 2024 11:37:11 GMT

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

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

Re: QlikView Bar Chart - Background colour not working with IF statement

NickBentley — Wed, 17 Apr 2024 23:16:33 GMT

Thank you Anil_Babu_Samineni.

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