How to map bar chart colors to their respective hex codes.
Hello,
I have a qlik table with the columns paint color and hex codes where paint color is the name of the paint code ex. red, and hex code is the hexidemcial code for red, random ex. #00956.
I want to create a bar chart and where paint name is the dimension on the x-axis and each bar is colored to the hex code that matched that paint name. How can I write an expression to do this?
