Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand
jagan
Partner - Champion III
Partner - Champion III

Hi,

Try like this

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

OR

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

Regards,

Jagan.

its_anandrjs
Champion III
Champion III

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
Partner - Champion III
Partner - Champion III

HI Rohit,

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

Regards,

Jagan.