Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

padma588
New Contributor

Mekko chart-Y-axis as a percentage

Hi All,

I'm having a problem with a mekko chart I'm working on.

>I have five dimensions as shown in the chart.

>The Y-axis has a scale of 0 to1.0. Is there some way i can convert this to a scale of 0 -100%.?

I tried the static min,max options but its not working.

Thanks again for you help.

Padmashri

8 Replies
venkatg6759
Contributor III

Re: Mekko chart-Y-axis as a percentage

Check the screenshot

bruno_montenegr
Contributor III

Re: Mekko chart-Y-axis as a percentage

Hi.

Just go to the Number tab of the chart properties and check "Show as percentage" for your expression.

padma588
New Contributor

Re: Mekko chart-Y-axis as a percentage

Hi Venkatg

Thanks for the reply.If i do this then the values inside the data points also appear as a percentage. I want to them to have calculated values and not % .

padma588
New Contributor

Re: Mekko chart-Y-axis as a percentage

Hi Bruno,

Thanks. I tried this but this happens.

venkatg6759
Contributor III

Re: Mekko chart-Y-axis as a percentage

Your Y axis is the expression .If you are giving relative it reflects the entire expression,

Not applicable

Re: Mekko chart-Y-axis as a percentage

Hi there,

Do you mind attaching your sample file.

Thanks

venkatg6759
Contributor III

Re: Re: Mekko chart-Y-axis as a percentage

Hi Padmasri,

You can make another chart and overlap something like the screenshot

bruno_montenegr
Contributor III

Re: Mekko chart-Y-axis as a percentage

In that case, the only thing I can think of is an ugly solution: configure the any way you like at the Number Tab and create a fake y-axis scale with text objects and place it over the real y-axis. Since the y-axis is always from 0 to 100%, you won't have a problem with things getting out of alignment.

Community Browser