topic Re: Mekko chart color in QlikView

Mekko chart color

Fri, 05 Sep 2014 23:50:11 GMT

I have tried every way possible to do this, but I can't figure it out.

In my application attached, there is a Mekko chart with the proper bar width and height; not concerned about the numbers within the bars.

I have a field called "status", it is either emerging or developed. I just want all the bars to be blue if developed or gray if emerging.

This is a tough one, the data is in an inline, with the LOAD under it; so it will reload.

This one, I can really use some expert help....

ecolomer — Sat, 06 Sep 2014 01:32:17 GMT

THis is ? Attached you have a possible solution

ecolomer — Sat, 06 Sep 2014 01:45:02 GMT

You can see also:

Sat, 06 Sep 2014 04:11:16 GMT

Enrique;

Thanks, but your answer does not solve the issue..

In my data, I have a field called Status; values are Development and Emerging.

I want the bars associated with Development one color, and the other bars associated with Emerging a different color. Is this possible?

Sat, 06 Sep 2014 04:46:27 GMT

Hi go through the file.

expression extension.

ecolomer — Sat, 06 Sep 2014 09:21:34 GMT

Ok, you can use an expression on the Color:

=if(Status='Emerging', RGB(100,100,100), If(Status='Developed', RGB(0, 150, 0)))

Mon, 08 Sep 2014 04:11:39 GMT

Hi,

use can color expression at expression level..

find the attachment.