Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Struggling to color a grouped bar chart

I need to build some bar charts with grouped information, like this:

Capturar.PNG

So far, it's set as Multicolored, but I wanted to pick the colors By Expression.

The thing is, each group of info in the bar come from a different colunm in my database ("Restaurants Revenue", "Coffee Places Revenue", "Candy Shops Revenue", and so on).

I know that if they were all in the same one, I could use something like IF([XXX]='YYY',Blue(),Red()), but all my measures come from different fields/columns, so I dunno how to organize the expression. What I've tried so far didn't work, so anyone has an idea to solve it? Thank you a lot in advance.

3 Replies
kidbank3
Contributor III

Re: Struggling to color a grouped bar chart

Mariana,

Other posts I've found say it's not possible and you need to pivot your data. 

Mike

Not applicable

Re: Struggling to color a grouped bar chart

Thank you, Michael.

I really need a chart to display that data.

Would you know another chart that could present the grouped info in different colors?

kidbank3
Contributor III

Re: Struggling to color a grouped bar chart

Nothing comes to mind but here are some posts with possible work arounds:

Custom color by expression for two different expressions

Re: How to use custom colours in a stacked bar chart

Community Browser