how to add percentage sign in Qlikview without multiplying 100

[dunnalahk123]

Hi,

Can some one help me how to add percentage sign in Qlikview with out multiplying 100.

Example:

i am getting my output value as     >>>>  3125  but i need to add  percentage to it  like below how can i do it.

3125 %

=Num(Avg(Aggr(Avg([TESTNEW]), [TESTNEWID])),'#,##0' )

Best Regards,

HK

[Chanty4u]

try

'#,##0.0%')

or 

num(your expression) '%'

[tresesco · Accepted solution]

If you need '%' just for displaying, you can use string concatenation like:

= <your expression> & ' %'

[dunnalahk123]

Thank You it works. 🙂

[qlikviewwizard]

Hi,

Please check this example.

Data:

LOAD * INLINE [

Group,Sales

A,1

B,2

C,3

D,4

];

Method1:

Method 2:

[sowmi]

In object properties under number you can select number format as percentage for the particular field.