I am having a graph depicting regions, but the problem is that the legend colors are very weird and also dont match up with the bars, Please find the image of the graph as attachment. Moreover i cannot use fixed expressions as the regions i get are not fixed, they can be anything. So no matching is possible. is it possible to let qlikview select a different color for every different entity(region) without the mixing of colors.
Though i managed to get the colors matching the graphs by removing the expression , but there is one thing, as i am using "buttons" to change the graphs, and there is an instance in which I have 5 buttons ,to make it more clear, an e.g., one for "priority" and the other for "region", now the thing is that, for priority I have strict color coding and fixed values also, like critical(red),high(yellow) and low(green). For which i used expression(RGB), but the region has no such limitation.
Is it possible for me to have such a graph, in which for one dimension i can provide expression for color, and for the others qlikview takes the values on its own without any weird color combinations.