topic Two-dimension Two-expression Mekko chart in QlikView

Two-dimension Two-expression Mekko chart

Thu, 12 Feb 2015 00:26:18 GMT

Hi everyone,

I would like to replicate this chart in QV. I believe it is a Mekko with the Style option for different heights. I would like one expression measured along the x axis and another along the y axis. It would have two dimensions, one for bar columns, the other stacking those bars.

Is this possible? How do I do it? I tried to make one, but an axes is only showing up for one expression, so I do not believe it is working.

Please see the attached example.

Re: Two-dimension Two-expression Mekko chart

Oleg_Troyansky — Thu, 12 Feb 2015 03:15:42 GMT

Hi Andrew,

I admit that Mekko charts are quite under-documented in QlikView. I included detailed explanations on how to build both "normalized" and "non-normalized" Mekko charts in my new book QlikView Your Business that's coming out in April. Check it out on Amazon.

For now, I'll give you some brief pointers here. The chart you are trying to build, is called the "non-normalized" Mekko chart. Traditionally, it's built with a single Dimension and several Expressions. The first expression drives the width of the columns, while the other expressions drive the heights of the stacked blocks.

So, instead of your second Dimension, create a number of expressions (looks like you'll need three) and use Set Analysis to filter each expression to the desired value of the Dimension.

good luck!

Oleg Troyansky

www.masterssummit.com

Re: Two-dimension Two-expression Mekko chart

Thu, 12 Feb 2015 16:26:50 GMT

Hi Oleg,

Thank you for your helpful response. I think I have the chart working! I will definitely check your book out, I have been looking for a new one for some time.

However, one question - how can I have a scale for the first expression appear along the X axis?

Re: Two-dimension Two-expression Mekko chart

Oleg_Troyansky — Thu, 12 Feb 2015 16:35:49 GMT

That, to be completely honest, I don't know. I doubt if it's possible using the "conventional" settings (I mean without overlaying something above or below the chart). The best I managed to do is to replace the Dimension labels with the values of the first expression, and even that was not cumulative...

Re: Two-dimension Two-expression Mekko chart

Thu, 12 Feb 2015 16:48:32 GMT

You're right - I tried "Text on Axis", and the values show up, but not in the right place.

Any ideas on how to create something I could lay overlay for the axis? I was thinking a horizontal stacked bar chart, but unfortunately you cannot create a stacked bar with one dimension and one expression.

Re: Two-dimension Two-expression Mekko chart

Oleg_Troyansky — Thu, 12 Feb 2015 17:04:52 GMT

Yes, you can!

1. Clone your Mekko chart and convert it to a Bar Chart.

2. Add a dummy dimension with the text "dummy" and promote it to the first position. Keep your original dimension in the second place

3. Leave the first expression and delete the rest of them.

4. Define the chart as Stacked and Horizontal.

5. Use transparent colors to hide everything but the X-Axis

6. In the Mekko chart, use transparent background to allow the second X-Axis to be seen from behind.

7. Align carefully and enjoy!

Oleg

Re: Two-dimension Two-expression Mekko chart

Thu, 12 Feb 2015 18:18:53 GMT

It worked, thank you!!!!!!

Re: Two-dimension Two-expression Mekko chart

Anonymous — Thu, 12 Feb 2015 19:22:16 GMT

this is exactly how i showed scales on a mekko chart i created.

Re: Two-dimension Two-expression Mekko chart

Anonymous — Thu, 22 Sep 2016 12:46:26 GMT

Hi Oleg,

Thanks for your answer ! I had a similar problem and it worked !

However, I converted the same to normalized chart and the first expression doesn't define the width anymore. Instead, it drives the height of the column. Anything I am missing here ?

Thanks,

Ashay

Re: Two-dimension Two-expression Mekko chart

Oleg_Troyansky — Mon, 26 Sep 2016 20:53:28 GMT

Hi Ashay,

yes, the normalized chart is different from the non-normalized chart... Instead of several expressions, you should have a single expression and two dimensions. The total value of the expression for the first dimension determines the width of the bar, and the distribution of the values for the second dimension determines the heights of the parts within each column.

I'm describing it in a lot of detail in my book QlikView Your Business.

cheers,

Oleg Troyansky