topic Decimal and percentage num in QlikView

Decimal and percentage num

Wed, 25 Nov 2020 16:16:04 GMT

Hello;

I have an expression in a chart that equals to say 21.7893 I want to show it as 21.8%, so percentage format with one decimal. How can I do it?

Re: Decimal and percentage num

ciaran_mcgowan — Fri, 08 Jul 2016 14:57:23 GMT

Num(FieldName, '0.0') & '%'

Re: Decimal and percentage num

sunny_talwar — Fri, 08 Jul 2016 14:58:28 GMT

May be one of these

Num(Expression, '##.0%')

Num(Expression/100, '##.0%')

Re: Decimal and percentage num

ciaran_mcgowan — Fri, 08 Jul 2016 15:00:27 GMT

Make sure you keep the % sign out of the expression or else, it will divide the field value by 100. So for 21.7893:

Num(FieldName, '0.0%') will equal 0.2% (.217893% narrowed down to 1 decimal place)

Re: Decimal and percentage num

Fri, 08 Jul 2016 15:02:52 GMT

great, it's Num(Expression/100, '##.0%'). Thanks!

Re: Decimal and percentage num

vishsaggi — Fri, 08 Jul 2016 15:07:58 GMT

Try this:

Num(<FieldName>, '#,##0.0%')

Go to Number tab in properties window, select field name and in number format settings select as below:

Re: Decimal and percentage num

Tue, 04 Oct 2016 08:33:16 GMT

Hi!

I'm sorry to refloat up this topic but I have a question.

I have one expression with the same configuration format that you, but my result instead 100.0% is 100,000.0% and I don't understand why.

Do you know if it could be a cause of a bad configuration? As curiosity, if I change dots per commas, in expression and number configuration, the result is 100,0%.

Thank you very much!!!!

Edit.: Solved! Setting dots per commas in the script.