Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
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
Highlighted
Creator III
Creator III

Check the screenshot

Highlighted
Creator III
Creator III

Hi.

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

Highlighted
Contributor
Contributor

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 % .

Highlighted
Contributor
Contributor

Hi Bruno,

Thanks. I tried this but this happens.

Highlighted
Creator III
Creator III

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

Highlighted
Not applicable

Hi there,

Do you mind attaching your sample file.

Thanks

Highlighted
Creator III
Creator III

Hi Padmasri,

You can make another chart and overlap something like the screenshot

Highlighted
Creator III
Creator III

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.