Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change number format on Y axis

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

2 Replies
swuehl
MVP
MVP

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

Not applicable
Author

Yes I have.

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