topic Re: Multicolor in combined Graphs in QlikView

Multicolor in combined Graphs

Mon, 15 Oct 2012 09:29:59 GMT

Hello!

I need to create a combined graphic, with bars and a line graphic.

Can I activate multicolor option in the bars graphic?

Thanks.

Re: Multicolor in combined Graphs

Gysbert_Wassenaar — Mon, 15 Oct 2012 09:34:35 GMT

Yes, add the dimensions and expressions. And choose how the expressions should be displayed (bar and/or line)

Re: Multicolor in combined Graphs

Mon, 15 Oct 2012 09:40:31 GMT

Thanks for the answer, but the problem is that when I choose that one expresion is the bars and the other is the line graphic, the multicolor option is desactivates and all my bars turn into green, and I need that each bar had its own color.

Re: Multicolor in combined Graphs

Gysbert_Wassenaar — Mon, 15 Oct 2012 09:49:20 GMT

Ah, yeah. The option on the colors tab is not available. But if you click on the + in front of the expression on the Expressions tab you can click on Background Color and change the expression to calculate a different background color for every bar.

Re: Multicolor in combined Graphs

Mon, 15 Oct 2012 09:57:30 GMT

OK, I´ve found it, but I don´t know how to change the color for each bar........

Re: Multicolor in combined Graphs

Gysbert_Wassenaar — Mon, 15 Oct 2012 10:01:46 GMT

for random colors: =rgb(floor(255*Rand()),floor(255*Rand()),floor(255*Rand()))

or you could use an if then statement

=if(Product='foo', Red(),if(Product='bar',Blue(),Green()))

Re: Multicolor in combined Graphs

Mon, 15 Oct 2012 10:07:02 GMT

Thanks a lot, finally I´ve made it