Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Conditional colour formating in a Mekko chart

Dear all,

I have a mekko chart, which has a dimension called Hiherarchy2. Hierarchy2 is a subgroup of Hierarchy1.

How can I have the same colour for all Hierarchy2 belonging to the same Hierarchy1?

Attached is a dummy app.

Thank you in advance for your help!

Regards

Tags (3)
1 Solution

Accepted Solutions

Re: Conditional colour formating in a Mekko chart

Yes, use for example something like =color(FieldIndex('Hierarchy1' ,Hierarchy1)) as background color expression. If you have a lot of values in Hierarchy1 (you do) you may want to consider creating a table in the script to assign colors to the Hierarchy1 values. See this blog post for more information: Colors in charts


talk is cheap, supply exceeds demand
2 Replies

Re: Conditional colour formating in a Mekko chart

Yes, use for example something like =color(FieldIndex('Hierarchy1' ,Hierarchy1)) as background color expression. If you have a lot of values in Hierarchy1 (you do) you may want to consider creating a table in the script to assign colors to the Hierarchy1 values. See this blog post for more information: Colors in charts


talk is cheap, supply exceeds demand
Not applicable

Re: Conditional colour formating in a Mekko chart

Thank you for the suggestion. Indeed color(fieldindiex ... works magically! But i'll need to create a separate table as there are so many value.

Thank you!

Community Browser