topic Re: Conditional colour formating in a Mekko chart in QlikView https://community.qlik.com/t5/QlikView/Conditional-colour-formating-in-a-Mekko-chart/m-p/610902#M548144 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 05 Feb 2014 17:07:58 GMT 2014-02-05T17:07:58Z Conditional colour formating in a Mekko chart https://community.qlik.com/t5/QlikView/Conditional-colour-formating-in-a-Mekko-chart/m-p/610900#M548142 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I have a mekko chart, which has a dimension called Hiherarchy2. Hierarchy2 is a subgroup of Hierarchy1.</P><P></P><P>How can I have the same colour for all Hierarchy2 belonging to the same Hierarchy1?</P><P></P><P>Attached is a dummy app.</P><P></P><P>Thank you in advance for your help!</P><P></P><P>Regards</P></BODY></HTML> Wed, 05 Feb 2014 16:15:43 GMT https://community.qlik.com/t5/QlikView/Conditional-colour-formating-in-a-Mekko-chart/m-p/610900#M548142 2014-02-05T16:15:43Z Re: Conditional colour formating in a Mekko chart https://community.qlik.com/t5/QlikView/Conditional-colour-formating-in-a-Mekko-chart/m-p/610901#M548143 <HTML><HEAD></HEAD><BODY><P>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: <A _jive_internal="true" class="font-color-normal" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/12/04/colors-in-charts" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3d3d3d;">Colors in charts</A></P></BODY></HTML> Wed, 05 Feb 2014 16:42:44 GMT https://community.qlik.com/t5/QlikView/Conditional-colour-formating-in-a-Mekko-chart/m-p/610901#M548143 Gysbert_Wassenaar 2014-02-05T16:42:44Z Re: Conditional colour formating in a Mekko chart https://community.qlik.com/t5/QlikView/Conditional-colour-formating-in-a-Mekko-chart/m-p/610902#M548144 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 05 Feb 2014 17:07:58 GMT https://community.qlik.com/t5/QlikView/Conditional-colour-formating-in-a-Mekko-chart/m-p/610902#M548144 2014-02-05T17:07:58Z