topic Re: Percentage symbol in QlikView

Percentage symbol

Wed, 25 Mar 2015 07:49:33 GMT

Hi All

I have a field

I need to show % at end of values like (0.21)%. i set it in Number properties, also used num(Expression,'#.##0,00%') but its not working ,any expression level script or properties to change?

Regards

Re: Percentage symbol

MK_QSL — Wed, 25 Mar 2015 07:56:06 GMT

Num(Expression,'#0.00%')

Re: Percentage symbol

Peter_Cammaert — Wed, 25 Mar 2015 07:56:50 GMT

How do you add parentheses to the small values? Are those negative values? In that case, add the % symbol to the format string in the Numbers tab.

Re: Percentage symbol

Wed, 25 Mar 2015 08:05:30 GMT

No its not working

my Expression is

=Num(if([Field (%)]/100<=0,0,

if([Field(%)]/100<1, '(' &[Field(%)]/100& ')',

if([Field(%)]/100>1,[Field(%)]/100))))

Re: Percentage symbol

Wed, 25 Mar 2015 08:12:39 GMT

Its default value if less than 0% will get parentheses.

Added % at num properties used but not working.

Re: Percentage symbol

Wed, 25 Mar 2015 08:14:42 GMT

Hi,

You can set in number tab like this.

Re: Percentage symbol

Wed, 25 Mar 2015 08:19:48 GMT

right but it showing to the values equal are more than 0%. like 0.00%, not to the values below Zero % which are in parentheses should be like (0.21)%

Re: Percentage symbol

MK_QSL — Wed, 25 Mar 2015 08:19:52 GMT

Remove /100 and try it...

Re: Percentage symbol

Wed, 25 Mar 2015 08:25:03 GMT

Hi,

You can arrange in Fixed to 1 or 2 or 3.......

Re: Percentage symbol

anbu1984 — Wed, 25 Mar 2015 08:27:07 GMT

=if([Field (%)]/100<=0,0,

if([Field(%)]/100<1, '(' &[Field(%)]/100& ')',

if([Field(%)]/100>1,[Field(%)]/100))) & '%'

Re: Percentage symbol

Peter_Cammaert — Wed, 25 Mar 2015 08:29:37 GMT

It works for me:

See the QVW document below.

Best,

Peter

Re: Percentage symbol

Wed, 25 Mar 2015 08:29:38 GMT

its calculation part need

Re: Percentage symbol

anlonghi2 — Wed, 25 Mar 2015 08:31:07 GMT

Hi Vamsi,

there is a parenthesis error, try with this:

Num(if([Field (%)]/100<=0,0, if([Field(%)]/100<1, '(' &[Field(%)]/100& ')',if([Field(%)]/100>1,[Field(%)]/100))),'#0.00%')

Re: Percentage symbol

Wed, 25 Mar 2015 08:34:02 GMT

Hi,

You can require like this (0.21)% . You can put Parenthesis (#,##0.0)%

Re: Percentage symbol

sudeepkm — Wed, 25 Mar 2015 08:34:35 GMT

it is not working as you have set the positive number format only.

you need to set the negative format too.

num(Expression,'#.##0,00%;(#.##0,00)%')

Re: Percentage symbol

Wed, 25 Mar 2015 08:46:42 GMT

only 0% is showing and other values like (0.21) are missing.

Re: Percentage symbol

Wed, 25 Mar 2015 08:50:57 GMT

All null values are also showing %

Re: Percentage symbol

buzzy996 — Wed, 25 Mar 2015 08:55:59 GMT

try,simply u have to select from NUMBER tab- show in percent chek and modify ur expression accordingly.

Re: Percentage symbol

Wed, 25 Mar 2015 08:58:12 GMT

Thank you Peter but not working ..

Re: Percentage symbol

Wed, 25 Mar 2015 08:58:59 GMT

only 0% is showing and other values like (0.21) are missing.