topic Re: Re: How to get % symbol in QlikView

How to get % symbol

Wed, 04 Jun 2014 11:28:53 GMT

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

Re: How to get % symbol

Wed, 04 Jun 2014 11:32:41 GMT

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 ###,#

Re: How to get % symbol

Wed, 04 Jun 2014 11:35:08 GMT

Hi Roberto

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

Re: How to get % symbol

Wed, 04 Jun 2014 11:44:37 GMT

....

Re: How to get % symbol

satishkurra — Wed, 04 Jun 2014 11:48:56 GMT

In Number Tab, Please check show in Percent Option

Re: How to get % symbol

CELAMBARASAN — Wed, 04 Jun 2014 11:50:03 GMT

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))

Re: Re: How to get % symbol

Wed, 04 Jun 2014 11:59:02 GMT

=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.

Re: How to get % symbol

Wed, 04 Jun 2014 11:59:43 GMT

Thanks Celambarasan

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

Re: How to get % symbol

its_anandrjs — Wed, 04 Jun 2014 12:02:31 GMT

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))

Re: How to get % symbol

Anonymous — Wed, 04 Jun 2014 12:07:34 GMT

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%)')

Re: How to get % symbol

its_anandrjs — Wed, 04 Jun 2014 12:10:23 GMT

If the % symbol in numbers back side if this ok then you can use like

=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) , '#,##0%')

Re: How to get % symbol

Wed, 04 Jun 2014 12:31:17 GMT

If you are using a text box then simply concat symbol '%' with & operator.

=(your expression) &' %'

Regards,

Lalit

Re: How to get % symbol

Wed, 04 Jun 2014 12:38:03 GMT

hi,

Yu can use like this

Re: How to get % symbol

vardhancse — Wed, 04 Jun 2014 12:52:22 GMT

what ever expression we want to display in %,

Right click on chart->Number(Tab)->Select any thing other than expression default->Show in percentage

1.we need to check the Show in percentage check box

2. We need to remove * 100 in the expression.

because as we are selecting the Show in percentage it will also multiple the value in to 100.

and no not required in expression