topic Change number format on Y axis in QlikView

Change number format on Y axis

Tue, 03 Jan 2012 13:47:46 GMT

Hi.

In order to be able to show both the sum of an expression and the percentage in the same graph I have created a button that changes the value of the variable "Procent" to 1 or 0.

In the chart I have done the following:

if(Procent = 1,

num(Sum (AntalTotalt)/Sum (TOTAL <ÅrMånad> AntalTotalt), '# ##0,0%'),

Sum (AntalTotalt)

)

I'm using the num() in order to change the values from 0,75 to 75%.

This works great in the actual chart but the Y-axis still shows 0,00 to 1 and not 0% to 100%.

Any ideas on how to fix this?

//Daniel

Change number format on Y axis

swuehl — Tue, 03 Jan 2012 14:24:36 GMT

On number tab, have you select the option "expression default" for that expression?

Change number format on Y axis

Tue, 03 Jan 2012 14:49:33 GMT

Yes I have.

Another thing that also isn't working is "others" in pie charts. They also show 0,0023.....