topic Re: Format Number as Percentage in QlikView

Format Number as Percentage

Tue, 27 Aug 2013 10:57:59 GMT

Hi Everyone

I need to dispaly number as percentage

Used num(value,'#,#0.0%')

does not work

Tue, 27 Aug 2013 11:03:06 GMT

Try #.##0,00% or #,##0.00%, depending on your decimal and thousand separators.

kaushiknsolanki — Tue, 27 Aug 2013 11:13:25 GMT

Hi,

What is the value of the field value and what you want to show.

If its 100 and you want to show 100% then the best way is

=Value&'%'

The reason is when you use the num (Value,'#,##0.00%')

This will multiply the number by 100 and then show as %.

Meaning in our example is you use num (Value,'#,##0.00%') where Value is 100

Then the output will be 10,000%.

Hope this is clear to you.

Regards,

Kaushik Solanki

Tue, 27 Aug 2013 11:16:41 GMT

Hi Kaushik

I have used =Value&'%' also but not getting the correct result.

All amounts are showed as 0.

kaushiknsolanki — Tue, 27 Aug 2013 11:19:13 GMT

Hi,

Is it possible for you to upload the application with some sample data, so that we can easily guide you to solution.

Regards,

Kaushik Solanki

gajapathy74 — Tue, 27 Aug 2013 11:22:49 GMT

what is your selection in the "Number Format Settings" tab?

Tue, 27 Aug 2013 11:26:50 GMT

It is Number

I changed it to Expression default.

now value & '%' is woking

Thanks