topic Re: Tough Mekko Question - Labels in QlikView

Tough Mekko Question - Labels

Sun, 09 Jun 2013 15:11:14 GMT

hi all,

I am trying to make a Mekko Chart with the breakdown of 3 Animal Categories and their subcategories. On the x axis I have Cat, Dog, Horse, and on the Y axis I have 0-100%. Can I make the mekko show the Sub Categories (Poodle, Collie, Dalmation) as the labels instead of the % values??

I have attached a spreadsheet with the values. I really appreciate your help!

Re: Tough Mekko Question - Labels

Gysbert_Wassenaar — Sun, 09 Jun 2013 16:30:05 GMT

You can use the dual function for this. You also need to enable the Plot Values Inside Segments option on the Presentation tab of the properties window. You do lose the option to format the Y-axis values as percentages though:

See attached example.

Re: Tough Mekko Question - Labels

Sun, 09 Jun 2013 18:19:48 GMT

Thank you so much - that was brilliant!

I have two follow up questions on this:

1. Is it possible to wrap the labels to fit the chart? I provided a simple sample of my full data so some of the labels are really long and don't fit the boxes.

2. Can you ever do a second drill down to this? As in, if I wanted to drill down into Persian to see the names of the owners, would I be able to do that? The dual function appears to have only one text string and one numerical value.

Thanks again!

Re: Tough Mekko Question - Labels

Gysbert_Wassenaar — Sun, 09 Jun 2013 18:40:13 GMT

1. No. You can enable the legend to show the labels elsewhere or use the left function to truncate the labels.

2. Create a drilldown group with Subcategory and Customername and use that group as dimension instead of Subcategory.

Re: Tough Mekko Question - Labels

Sun, 09 Jun 2013 19:59:56 GMT

Thank you so much for your prompt and spot-on help!

Re: Tough Mekko Question - Labels

Tue, 28 Jan 2014 09:03:23 GMT

Hello,

I tried the Dual function, but couldnt get it to work! Im not managing to display the labels in the chart!

Could you please suggest?

Regards

Re: Tough Mekko Question - Labels

Thu, 15 May 2014 21:24:04 GMT

Hi Gysbert,

Is it possible to display totals on top of 'Cats' , 'Dogs' , etc... when i pick 'show totals' it adds an entire box at the top, which i dont want. I would like to simply show a numeric value.

Thanks for your help.

Prashant