topic Percentages in axes of mekko chart in QlikView

Percentages in axes of mekko chart

Thu, 12 Jan 2012 12:11:16 GMT

Hi guys,

Please take a look at the qvw attached.

There is a Mekko chart.

Does anyone knows how to:

.- Show Axis values as percentages ==> 70% instead of 0.7
.- Show Expresion values into expresison background, i.e. 8991 into green color
.- Show expression also as %, i.e. 8991 - 74%

Thanks in advance,

Aldo.

Re: Percentages in axes of mekko chart

kji — Thu, 12 Jan 2012 12:33:54 GMT

Set the number format on "Numbers" tab using "Show in Percent(%)" option (for all 3 expressions).

On the presentation tab select "Plot Values Inside Segments"

Change all expressions to be normalized:

Sum([Ex Stock]) into Sum([Ex Stock])/(Sum(Late)+Sum([On Time])+Sum([Ex Stock]))

and same for the others.

Percentages in axes of mekko chart

Thu, 12 Jan 2012 12:38:23 GMT

Hey Hi Aldo,

Just go to Properties->Number ,then select your expression and in number select format check Number ->check Show in% at bottom.

It may help you..

thax

Re: Percentages in axes of mekko chart

Thu, 12 Jan 2012 12:41:01 GMT

Sorry, I thought it was the solution I was looking for, but actually setting all exp. to %, makes all bars to have the same width (or looks like) and I need to bolt the different volumes over YM.

Aldo.

Message was edited by: Aldo Liaks

Re: Percentages in axes of mekko chart

Wed, 13 Nov 2013 08:16:18 GMT

Hi Aldo, did you find a solution for this? I see the same problem... thanks in advance Leandro

Re: Re: Percentages in axes of mekko chart

mdmukramali — Wed, 13 Nov 2013 09:03:40 GMT

Dear Leandro Duarte,

Kindly find the attachment.

I hope it will help you.

Thanks,

Mukram.

Re: Percentages in axes of mekko chart

Wed, 13 Nov 2013 12:05:45 GMT

Hi Mukran, the idea is to have the values in the chart in absolute value, but only the Y axis to be in %. it is already today 0.5 something.. but in the end the best display for this is %

thanks Leandro

Re: Percentages in axes of mekko chart

Mon, 09 Mar 2015 15:15:24 GMT

Hello Leandro,

have you been lucky with finding a solution for this challenge? If so can you please share your insights here?

Thank's and bests

Peter

Re: Percentages in axes of mekko chart

Wed, 04 Jan 2017 14:18:32 GMT

Hi Aldo, Peter,

I've figured out a solution for this problem.

Clue is

- Use a one-dimension, multi-expression Mekko (as you did, but that was not my start)

- Add an extra 0 expression, with number formatting percentage

- Make from your values Duals, with as text representation the percentage of the vertical bar, and as number the absolute value

See attachment!

Re: Percentages in axes of mekko chart

Fri, 23 Jun 2017 12:28:07 GMT

not really, I need to look this case again