topic Re: Chart legend order reverses in QlikView

Chart legend order reverses

Anonymous — Wed, 17 May 2017 14:25:17 GMT

I have created two charts using the same data. When I create a mekko chart the legends reverse and the colours are backwards from the pie chart.

I figured out that I had to reverse the order in the mekko chart to get them in the correct order, but how do I get the colours to match between the two charts?

Thank you

Re: Chart legend order reverses

neelamsaroha157 — Wed, 17 May 2017 14:30:12 GMT

I am not sure but you can try checking 'Persistent Color' option on color tab.

Re: Chart legend order reverses

Anonymous — Wed, 17 May 2017 14:30:40 GMT

Hi,

You can use in your background color this kind of formula : =Color(FieldIndex('Country',Country))

Country is a dimension and you will have the same color for each country if you apply the color background in your charts ( mekko and piechart)

Re: Chart legend order reverses

Anonymous — Tue, 06 Jun 2017 10:17:56 GMT

I can get the colours to match by reversing the order of the Expressions in the Mekko chart, but then, of course, they appear in reverse order on the legend.

Re: Chart legend order reverses

Anonymous — Tue, 06 Jun 2017 10:19:34 GMT

In the pie chart the Expression is a count of the category. For the Mekko chart I've had to list the count of each of the categories as a separate Expression.

Still no joy on this one. Seems odd that the Mekko chart displays the legend in the opposite order to the Expressions.

Re: Chart legend order reverses

Anonymous — Tue, 06 Jun 2017 15:53:06 GMT

Could you post a sample?