topic Re: Advanced Mekko chart extension in Integration, Extension & APIs

Advanced Mekko chart extension

Joe-Dormer — Tue, 22 Jun 2021 16:03:35 GMT

Hi,

I wonder if anyone can assist?

I am looking to create a mekko / marimekko/ mosiac plot chart with three measures, stacked on top of one another and a fourth measure to represent the width of each Dimension in the chart.

I have been trying to build this in Qlik Sense using the standard Mekko chart, however I am only able to add one Measure.

Can anyone recommend a new method or extension that will produced results similar to the below image?

The three colours (blue, orange and green) would represent the three different measures.

Please let me know if you need any additional information.

Thanks

Joe

Re: Advanced Mekko chart extension

chrismarlow — Tue, 22 Jun 2021 16:44:17 GMT

Hi,

I think you might be able to use ValueList & Pick/Match to make the existing Mekko use the second dimension to split between three of your measures.

I think then you may also need to apply some kind of factor to the numbers so the width represents the 4th measure, so contrast right chart below (where the measures have been scaled to represent the fact that mea4 splits 50/50) with left (where it does not). This does mean the numbers on the blocks probably need hidden as suspect they would be misleading.

I've attached the toy QVF as the formulae get quite long.

Cheers,

Chris.

Re: Advanced Mekko chart extension

Joe-Dormer — Wed, 23 Jun 2021 12:57:19 GMT

Thank you for this great solution Chris, it does exactly what we needed!

Much appreciated,

Joe