Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
aaronnayan
Contributor III

in chart text expression in a percentage to 1 decimal point

Hi guys how do i put my expression in a percentage to 1 decimal point?

Also to 2 decimal points please

4 Replies
Not applicable

Re: in chart text expression in a percentage to 1 decimal point

num() function, like

num(your calculation here, '##.#') will give you one decimal place

aaronnayan
Contributor III

Re: in chart text expression in a percentage to 1 decimal point

I need it as a percentage Aaron

vishsaggi
Esteemed Contributor III

Re: in chart text expression in a percentage to 1 decimal point

Can you share your expression you want %ge ?

As Aaron said use Num(expr, ###0.00%)

OR

use chart properties -> Number tab -> Fixed radio button check.

Not applicable

Re: in chart text expression in a percentage to 1 decimal point

num(your calculation here, '##.#') & '%'

Just add a % on the end. If you need to calculate it into a percent, multiply by 100