Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
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