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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get % symbol

HI All ,

   Iam using a text box to display the difference between current year and previous year and  it is working fine , what i want to know is i want to display the % symbol infront of the symbol ,

The text box has the following expression :=(Round((num(sum({$<Year = {$(=max(Year - 1))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} NET_AMOUNT), '$#,##0;($#,##0)')/num(sum({$<Year = {$(=max(Year))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} MonthNames))"}>} NET_AMOUNT), '$#,##0;($#,##0)'))*100))

Give me any suggestion

Thanks in advance

13 Replies
Not applicable
Author

You can surround your expression with num( <here your expression as argument 1>, <here the numberformat as argument 2>)

number format (when it is a percentage with 1 decimal can be ###,#

Not applicable
Author

Hi Roberto

   Thanks for ur reply , can u plz alter my expression , iam facing difficulty in understanding it , can u plz

Not applicable
Author

....

satishkurra
Specialist II
Specialist II

In Number Tab, Please check show in Percent Option

CELAMBARASAN
Partner - Champion
Partner - Champion

You can use like this also

='%' & (Round((num(sum({$<Year = {$(=max(Year - 1))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} NET_AMOUNT), '$#,##0;($#,##0)')/num(sum({$<Year = {$(=max(Year))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} MonthNames))"}>} NET_AMOUNT), '$#,##0;($#,##0)'))*100))

Not applicable
Author

=num( (Round((num(sum({$<Year = {$(=max(Year - 1))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} NET_AMOUNT), '$#,##0;($#,##0)')/num(sum({$<Year = {$(=max(Year))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} MonthNames))"}>} NET_AMOUNT), '$#,##0;($#,##0)'))*100)) ,'####,#')


Assuming that , is your decimal separator.

If your decimal separator is a . (dot) then replace ####,# with ####.#


Celambarasan Adhimulam's option however seems a bit easier by the way.

Not applicable
Author

Thanks Celambarasan

  I copied and pasted the expression u gave , but its showing error , can u plz help me out

its_anandrjs
Champion III
Champion III

I believe what Celambarasan suggest like put in front of the expression

='%' & (Round((num(sum({$<Year = {$(=max(Year - 1))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} NET_AMOUNT), '$#,##0;($#,##0)')/num(sum({$<Year = {$(=max(Year))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} MonthNames))"}>} NET_AMOUNT), '$#,##0;($#,##0)'))*100))

Anonymous
Not applicable
Author

Use:

num(Round((num(sum({$<Year = {$(=max(Year - 1))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} NET_AMOUNT), '$#,##0;($#,##0)')/num(sum({$<Year = {$(=max(Year))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} MonthNames))"}>} NET_AMOUNT), '$#,##0;($#,##0)'))),'$#,##0%;($#,##0%)')