Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Lisa2
Contributor
Contributor

Need to Add a Percent Symbol

Hello,

I need to add a percent symbol to the end of a result number being used in a gauge chart.  I have:

=Num(Round(max({<[Col A]={MAX}>}[Col B]),0.01),'#0.00%')

The rounded number comes out as 100.00 but when I add the percentage formatting it comes out as 10000.00% but I need it to be  100.00%

If someone could point me in the right direction.

Thanks.

 

 

Labels (1)
1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

Num(Round(max({<[Col A]={MAX}>}[Col B])/100,0.01),'#0.00%')

 

1 is 100%

100 is 10000%

 

hope this helps

View solution in original post

1 Reply
Frank_Hartmann
Master II
Master II

Num(Round(max({<[Col A]={MAX}>}[Col B])/100,0.01),'#0.00%')

 

1 is 100%

100 is 10000%

 

hope this helps

View solution in original post