topic Re: Mekko chart in QlikView

Mekko chart

Wed, 12 Sep 2012 01:09:46 GMT

I am unfamiliar with Mekko charts, but think this may be the chart that I need to use to graph volume vs cost.

For eg. I want to chart volume vs cost for a number of plants. The plant is not the lowest level of data, but the relevant level that I want to show.

Attached is a screen shot of the required chart that was done in excel. This shows cumulative volume on the x-axis and costs on the y-axis.

Any help would be greatly appreciated, and a qvw example would be fantastic.

Thanks

Re: Mekko chart

rwunderlich — Wed, 12 Sep 2012 23:27:08 GMT

You can reproduce something similar with a Mekko chart. See attached. I'm not sure how to get the Volume scale to show along the bottom though.

-Rob

Re: Mekko chart

Wed, 12 Sep 2012 23:38:08 GMT

Hi Rob,

Instead of the volume scale along the bottom, is it possible to show the volume as a value on each of the bars (either individual volumes or accumulated)?

Thanks

Re: Mekko chart

whiteline — Fri, 14 Sep 2012 15:21:50 GMT

I think, with mekko its not possible.

You can try a bar chart with thin bars without gaps between.

Re: Mekko chart

rwunderlich — Fri, 14 Sep 2012 22:16:22 GMT

The decoration options for Mekko charts seem to be very limited. I can't find a way to get useful volume numbers to display on the chart.

-Rob

Re: Mekko chart

Mon, 27 Jan 2014 22:27:43 GMT

Dear Rob,

IS there a way to display the legends inside the Mekko chart?

THank you in advance!

Re: Mekko chart

phaneendra_kunc — Mon, 27 Jan 2014 22:55:36 GMT

it will show up if you have more than 2 expressions...

1st expression will decide your Width of the bar..

2nd Expression will decide the Height

3rd expression will be stacked to your 2nd based on the dimension..

Re: Mekko chart

Tue, 28 Jan 2014 09:07:21 GMT

Dear Phaneendra,

I tried the suggestions.

Still not being able to display the legends inside the chart.

Attached is the example.

Thanks a ton in advance!

Re: Re: Mekko chart

phaneendra_kunc — Tue, 28 Jan 2014 17:40:04 GMT

this is not what you are expecting? i mean legend for Company..

Re: Mekko chart

alis2063 — Fri, 22 Sep 2017 18:04:02 GMT

is this only to show the analysis between Volume vs Cost?

Or we can use them for other analysis