topic Re: Re: Display label inside Mekko Chart in QlikView

Display label inside Mekko Chart

Mon, 27 Jan 2014 18:00:41 GMT

Hello,

Is it possible to display the Legends/ Labels of the dimensions inside the Mekko Chart instead of having the legends list separately?

Thank you very much in advance!

Re: Display label inside Mekko Chart

Tue, 28 Jan 2014 09:18:09 GMT

Attached the example application.

Re: Re: Display label inside Mekko Chart

Nicole-Smith — Tue, 28 Jan 2014 15:53:23 GMT

See the attached.

This should give you everything you want. The only thing you lose is the axis being formatted as a percentage. I don't believe you can get around this because on the Numbers tab, the expression must be set to Default or it will not display the label.

Re: Re: Display label inside Mekko Chart

Tue, 28 Jan 2014 16:03:53 GMT

Wow, you are a genius!

I had tried using it with Dual, but i guess it was not the right format.

Thanks a million!

Regards,

Re: Display label inside Mekko Chart

Wed, 29 Jan 2014 15:05:29 GMT

Hi Nicole,

I have another minor problem. Actually the sales data is in number format. I need to display a relative percentage. I tried with using an aggr, but its buggy.

Ideally in the mekko chart it would be good to have the label: number : percentage.

Could please have a look? Do you think its possible?

Thanks again!

Re: Re: Display label inside Mekko Chart

Nicole-Smith — Wed, 29 Jan 2014 15:25:28 GMT

Like this? (See the attached.)

Re: Re: Display label inside Mekko Chart

Wed, 29 Jan 2014 15:59:11 GMT

Something like this, but the Total function doesnt take into account the dimensions, right?

As the Total has to be by MediaType. That's why I was trying the AGGR, but it doesnt calculate for all the lines!

Re: Re: Display label inside Mekko Chart

Wed, 29 Jan 2014 16:06:02 GMT

The question is how to formulate the expression so that it functions like the relative function works for the expression.

Re: Re: Re: Display label inside Mekko Chart

Nicole-Smith — Thu, 30 Jan 2014 16:49:52 GMT

Like this? (See the attached.)

Re: Display label inside Mekko Chart

Thu, 30 Jan 2014 17:00:31 GMT

Yep exactly, had figured it out, and it also works using aggr(nodistinct

sum( ....))

Thank you anyway!

Regards,

Re: Re: Display label inside Mekko Chart

Thu, 06 Feb 2014 14:30:36 GMT

Hi Nicole,

One last question, i think i discovered a bug!

If i limit the dimensions, the chart label for Others doesnt display any text. Do you think there is a work around for that?

Thanks a ton again

Regards,

Re: Re: Re: Display label inside Mekko Chart

Nicole-Smith — Thu, 06 Feb 2014 14:51:53 GMT

How about this? (See the attached.)

Re: Re: Re: Display label inside Mekko Chart

Thu, 06 Feb 2014 15:03:58 GMT

Your solutions, don't stop to amaze me!

Re: Re: Re: Display label inside Mekko Chart

Thu, 06 Feb 2014 15:24:19 GMT

I dont know if i should continue in this thread or open a new one. It's the same Mekko, but now a problem with the colour.

1) I have a dimension Child which is a hierarchy of another dimension Parent. And all the child colours should have the same colour as the parent.
However the Parent contains some NULL values, which is colouring the whole Mekko in Black.

2) I have used limit Dimensions, which I want it to be in grey, but that too is blacking out.

Is the data quality the only solution, or any other wiked suggestions? ^^

Thank you

Re: Re: Re: Re: Display label inside Mekko Chart

Nicole-Smith — Thu, 06 Feb 2014 15:35:26 GMT

Have a look at the attached. Let me know if it works for you.

Re: Display label inside Mekko Chart

Thu, 06 Feb 2014 15:46:06 GMT

Nice trick with the mod function for colours, never used it before.

Actually just need the Others (Autres field) which comes from the

dimensional limits to be in grey, and for the colour of the rest of the

blocks, all the Child from the same parent need to have the same colour.

I think it's a problem with the data quality, tried suppressing all null

values, but it didnt work.

Re: Re: Display label inside Mekko Chart

Nicole-Smith — Thu, 06 Feb 2014 15:51:19 GMT

Like this? (See the attached.)

Re: Display label inside Mekko Chart

Thu, 06 Feb 2014 16:01:06 GMT

Just perfect!!

Thanks a million!!! You're a Genius!

Re: Re: Display label inside Mekko Chart

Fri, 07 Feb 2014 09:28:05 GMT

Hi Nicole,

I tried the color(fieldindex thing for dynamically assigning the colours. In the current selection in the app attached i need different shades of green for the same dimension for the particular condition. I think its the aggr which is messing it up?

I go the NULLS corrected.

Thank you!

Re: Re: Display label inside Mekko Chart

Nicole-Smith — Fri, 07 Feb 2014 13:48:48 GMT

The aggr() isn't what's messed up, it's the vR, vG, and vB values that are assigning the same green to all of them:

You'll need to fix the way you're assigning those variables if you want the colors to be different. Maybe try the color wizard.