Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

hi

Hi Everyone,

I got result   '.89'    like this in my chart.

I want to show this number like   ' .89% '

How I do this?? is this possible to show?

please help, thank you

8 Replies
Gysbert_Wassenaar

Try  = '.89'  & '%'


talk is cheap, supply exceeds demand
Not applicable
Author

hi wassenaar thank for your reply,,

but i have selected values on data points option, in chart i am getting the values as .89 and i want show as .89%, if i select show in percent option, i will get as 89%, but i am looking for .89%, i dont know its possible to show or not.

thank you

MK_QSL
MVP
MVP

Try something like

Num(YourExpression,'#0.00%')

Gysbert_Wassenaar

Divide the value by 100 and then format is as a percentage: num(MyValue/100, '#0.00%')


talk is cheap, supply exceeds demand
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

=Num(0.89/100,'#0.00%')

OR

=Num(FieldName/100,'#0.00%')

Regards,

Jagan.

its_anandrjs

Hi,

If this is only value then try with this

=.89&'%'

Or will it come from expression then Num( Expression, '###.0%')

Regards,

Anand

Not applicable
Author

Thank you all, its working , nice platform i gt answer

jagan
Luminary Alumni
Luminary Alumni

HI Rohit,

Close this thread by giving correct and useful answers for those posts which helps you in getting the solution.

Regards,

Jagan.