topic Re: Customised sorting in Mekko Chart in QlikView

Customised sorting in Mekko Chart

Wed, 25 Nov 2020 16:16:04 GMT

I’ve created one Mekko chart. It has two dimension.

I need Customised sorting

For 1st Dimension from Left to Right as E, W, N, S & G
For 2nd Dimension from bottom to top – F, O, T, D

How to get the above customized sorting in the Mekko chart view

Re: Customised sorting in Mekko Chart

Digvijay_Singh — Mon, 25 Jul 2016 10:13:34 GMT

Please share some sample data if possible.

Re: Customised sorting in Mekko Chart

vcanale — Mon, 25 Jul 2016 10:20:21 GMT

Hi,

If none of the standard sorting available is suitable for your case, you can think about a Sorting Expression and select Expression in the Sort Tab in the Chart Properties

Re: Customised sorting in Mekko Chart

Mon, 25 Jul 2016 10:30:29 GMT

Hi,

Tried doing this, but it is working for 1 dimension and not for another

Re: Customised sorting in Mekko Chart

ashwanin — Mon, 25 Jul 2016 10:35:55 GMT

Can you share sample data?

Re: Customised sorting in Mekko Chart

Mon, 25 Jul 2016 10:55:12 GMT

Hi,

With Expression I was able to do so. Thanks

Re: Customised sorting in Mekko Chart

Mon, 25 Jul 2016 11:02:35 GMT

Another query,

The second Dimension Labels are appearing as Legends, How can I show them as Labels against Y-axis, i.e. Vendor Name, instead of Legend want to show them against respective Mekko bar

Re: Customised sorting in Mekko Chart

vcanale — Mon, 25 Jul 2016 11:39:34 GMT

working fine for both dimensions now ?

Re: Customised sorting in Mekko Chart

Mon, 25 Jul 2016 11:54:27 GMT

Yes, very much

Re: Customised sorting in Mekko Chart

vcanale — Mon, 25 Jul 2016 11:54:52 GMT

Not sure it's possible to do it.. normally you see Numerical Values on Y-axis

Re: Customised sorting in Mekko Chart

Mon, 25 Jul 2016 12:08:22 GMT

HI,

Generally, this is available in Third-party tools