Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text object: expression for 'percentage'

Dear All,

I use in a text object the following expression to calculate a ratio: =(SCORE/Avg(total(SCORE)).

How is it possible to show this ratio as percentage? I want to change a ratio of 0,1 to 10%.

Much thanks! Arthur

2 Replies
sridhar240784
Creator III
Creator III

Hi,

Try below expression.

=Num((SCORE/Avg(total(SCORE)),'##.00%')

-Sridhar

Not applicable
Author

Hi Sridhar,

Somehow it doesn't work. Do you know why - see below:

Schermafbeelding 2011-12-03 om 17.07.33.png