Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
This should work, Could be you don't have in bar with 2023 data?
Or, try with Pick(Match(SSDate_CY, 2023), RGB(....))
This should work, Could be you don't have in bar with 2023 data?
Or, try with Pick(Match(SSDate_CY, 2023), RGB(....))